fulltext suggestion for Simple Chinese
Posted: Thu Feb 28, 2013 1:52 am
Script URL:
Version of script: 2.41
Hosting company:
URL of phpinfo.php:
URL of session_test.php:
What terms did you try when SEARCHING for a solution:
Write your message below:
I knew mysql can't support Chinese fulltext suggestion, I have a testing installation of hesk 2.41, normally when user start typing in Chinese there is no suggestion result, but today I found some articles show up when I typed in Chinese, that surprise me, see pic:
so I took a look in db found the content of article changed to something like this:
no idea what happened, who know?
thx.
Version of script: 2.41
Hosting company:
URL of phpinfo.php:
URL of session_test.php:
What terms did you try when SEARCHING for a solution:
Write your message below:
I knew mysql can't support Chinese fulltext suggestion, I have a testing installation of hesk 2.41, normally when user start typing in Chinese there is no suggestion result, but today I found some articles show up when I typed in Chinese, that surprise me, see pic:
so I took a look in db found the content of article changed to something like this:
I upgraded it from 2.3 to 2.41 then convert the charset from utf8_general_ci to utf8_unicode_ci.<p><span style="font-size: 10.5pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial;"><span style="font-family: 宋体;">简体中文</span></span><span style="font-size: 10.5pt; font-family: 'Arial','sans-serif';" lang="EN-US">ABC</span><span style="font-family: 宋体;"><span style="font-size: 10.5pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial;">设备，可以支持移动设备无线简体中文</span></span></p>
<p><span style="font-size: 10.5pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Calibri; mso-bidi-font-family: Arial; mso-fareast-font-family: 宋体; mso-bidi-font-size: 11.0pt; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin;"><span style="font-family: 宋体;">简体中文</span></span><span style="font-size: 10.5pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Calibri; mso-bidi-font-family: Arial; mso-fareast-font-family: 宋体; mso-bidi-font-size: 11.0pt; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin;"><span style="font-family: 宋体;">：</span></span><span style="font-size: 10.5pt; font-family: 'Arial','sans-serif'; mso-fareast-font-family: 宋体; mso-bidi-font-size: 11.0pt; mso-fareast-theme-font: minor-fareast;"> <span lang="EN-US">Rookie II, Ksiyu II , Herakles</span></span></p>
<p><span style="font-size: 10.5pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Calibri; mso-bidi-font-family: Arial; mso-fareast-font-family: 宋体; mso-bidi-font-size: 11.0pt; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin;"><span style="font-family:
no idea what happened, who know?
thx.