Knowledgebase search and multibyte characters

User Name · **Knowledgebase search and multibyte characters -** 08-06-2006, 01:17 AM

The current search code will not work with multibyte languages such as Chinese, Japanese and Korean. Go to functions_sqlsearch.php inside esupport/includes and modify the following section:

Code:

// Sanitize the text
        $stopdata = array("#\s+#s", "#(\r\n|\r|\n)#s", "/[^a-zA-Z0-9\x80-\xff]/");
        $replacewith = array(" ", " ", "");
        $_query = preg_replace($stopdata, $replacewith, $query);

As above, modify the $stopdata variable. The \x80-\xff part will allow multibyte characters.

***Varun Shoor*** · 08-06-2006, 01:37 AM

The fix is in the next build. Thanks for sharing.

Regards,

Varun Shoor

Chow · 01-11-2006, 02:14 AM

Have the problem be fixed? If so can I have the hosted plan upgraded to the latest version??

User Name · 01-11-2006, 05:41 AM

Not fixed yet, as far as I can tell. They changed the code, but it still doesn't work with multibyte characters. The code I posted above does work.

triller · 01-11-2006, 11:07 AM

Hi, User Name, I have send you a PM, let's keep in touch for SS experience share.

tian · 22-12-2006, 12:45 PM

is it fiexed now?

Mahesh Slaria · 23-12-2006, 04:35 AM

Hi,

Yes, multibyte characters search is fixed in our latest CVS build. You can download and test it.

Thanks.

Regards,

triller · 23-12-2006, 10:59 AM

Quote:

Originally Posted by Mahesh Slaria

Hi,

Yes, multibyte characters search is fixed in our latest CVS build. You can download and test it.

Thanks.

Regards,

Can I know which exact CVS build you mentioned ? As I had been told the problem fixed in latest CVS build but actually not.

BTW, we still need to rebuild the ticket index after upgrade ?

triller · 25-12-2006, 12:15 AM

Tried the lasted CVS build, 3.04.51 (CVS) - 24 Dec 2006 01:13 AM, nothing changed, still can not search Chinese in ticket message...

Dancy · 20-01-2007, 12:23 AM

Greetings,

Any update on this ?

triller · 06-03-2007, 01:09 PM

This problem is not fixed in V3.10 yet, anybody can update the progress ?

bsS · 16-06-2008, 12:17 PM

What about arabic charset?
specially in rss when you submit ticket the ajax have problem to search the kb for arabic content

jnet · 16-06-2008, 12:48 PM

wait a min you mean this problem could easily be solved and I was suffering so much

Right now I will give it a try

thanks

jnet · 12:59 PM

I will try it tomorrow

Razzaq · **help -** 17-06-2008, 07:02 AM

Hi, i have a client's site

Last month, our site has a very good ranking in google, but in this month ,

ranking is suddently fallys on our keywords.

But the keywords ranking in Yahoo is very much increased.
I can not understand why this is done by google.

Can any body give me some suggestion

Regards

Property Directory | Wholesale Billiards
Wholesale Batteries |Stock Brokers Directory

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

*Varun Shoor* Offline Chief Executive Officer Posts: 2,829 Join Date: May 2003	08-06-2006, 01:37 AM The fix is in the next build. Thanks for sharing. Regards, Varun Shoor Varun Shoor (varun.shoor ]at[ kayako.com) ------------------------------------------------------------------- New to the forum? New user's guide here. Submit a bug report here. Submit support tickets via the members area. Submit sales queries either via live chat or via e-mail.

Chow Offline New Member Posts: 14 Join Date: Jul 2006 Location: Hong Kong	01-11-2006, 02:14 AM Have the problem be fixed? If so can I have the hosted plan upgraded to the latest version??

User Name Offline Member Posts: 116 Join Date: May 2005	01-11-2006, 05:41 AM Not fixed yet, as far as I can tell. They changed the code, but it still doesn't work with multibyte characters. The code I posted above does work. PHP 5.1.5 MySQL 5.0.24 eSupport 3.04.10 (Zend, self-hosted)

triller Offline Member Posts: 52 Join Date: Apr 2006	01-11-2006, 11:07 AM Hi, User Name, I have send you a PM, let's keep in touch for SS experience share.

tian Offline Member Posts: 67 Join Date: Dec 2006	22-12-2006, 12:45 PM is it fiexed now?

Mahesh Slaria Offline Member Posts: 183 Join Date: Jul 2006	23-12-2006, 04:35 AM Hi, Yes, multibyte characters search is fixed in our latest CVS build. You can download and test it. Thanks. Regards,

triller Offline Member Posts: 52 Join Date: Apr 2006	25-12-2006, 12:15 AM Tried the lasted CVS build, 3.04.51 (CVS) - 24 Dec 2006 01:13 AM, nothing changed, still can not search Chinese in ticket message...

Dancy Offline New Member Posts: 2 Join Date: Mar 2006	20-01-2007, 12:23 AM Greetings, Any update on this ?

triller Offline Member Posts: 52 Join Date: Apr 2006	06-03-2007, 01:09 PM This problem is not fixed in V3.10 yet, anybody can update the progress ?

bsS Offline New Member Posts: 1 Join Date: May 2008	16-06-2008, 12:17 PM What about arabic charset? specially in rss when you submit ticket the ajax have problem to search the kb for arabic content

jnet Offline Member Posts: 527 Join Date: Mar 2008	16-06-2008, 12:48 PM wait a min you mean this problem could easily be solved and I was suffering so much Right now I will give it a try thanks

jnet Offline Member Posts: 527 Join Date: Mar 2008	16-06-2008, 12:54 PM I will try it tomorrow Last edited by jnet; 16-06-2008 at 12:59 PM.