fulltext suggestion for Simple Chinese

Helpdesk for my helpdesk software

Moderator: mkoch227

Post Reply
deserteagle369
Posts: 94
Joined: Wed Feb 29, 2012 2:00 am

fulltext suggestion for Simple Chinese

Post by deserteagle369 »

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:
Image

so I took a look in db found the content of article changed to something like this:
<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:
I upgraded it from 2.3 to 2.41 then convert the charset from utf8_general_ci to utf8_unicode_ci.

no idea what happened, who know?

thx.
Eagle
Life is a journey.
Klemen
Site Admin
Posts: 10147
Joined: Fri Feb 11, 2005 4:04 pm

Re: fulltext suggestion for Simple Chinese

Post by Klemen »

The content of article was stored as HTML even in 2.3. Perhaps you had some encoding problems earlier that were fixed by moving to utf-8, don't know really?
Klemen, creator of HESK and PHPJunkyardWas this helpful? You can buy me a drink here Image

Image You should follow me on Twitter here

Help desk software | Cloud help desk | Guestbook | Link manager | Click counter | more PHP Scripts ...

Also browse for php hosting companies, read php books, find php resources and use webmaster tools
Post Reply