Quicksearch using Chinese not working?

Random stuff about serendipity. Discussion, Questions, Paraphernalia.
Post Reply
hdiaz36
Regular
Posts: 57
Joined: Wed Feb 21, 2007 6:57 pm
Location: China (Yes, really)

Quicksearch using Chinese not working?

Post by hdiaz36 » Sun Oct 28, 2007 8:12 pm

One part of our website uses both English and Chinese.

I just noticed today that if a user uses Chinese to search that they cannot find anything, instead getting the message: "No Entries Found for Query 'x' " - where x is some Chinese word or expression.

Take for example - 夜猫子 (Simplified characters) yè mào zi (Chinese pinyin)

If you search for either of those you will find nothing. :(

This is a serious problem for me as in the future being able to search using Chinese will be a vital aspect of the website.

Any help with this would be greatly appreciated.

Thank you! :)

PS: Here is a link - English and Chinese language help
Image

User avatar
garvinhicking
Core Developer
Posts: 30020
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Quicksearch using Chinese not working?

Post by garvinhicking » Mon Oct 29, 2007 12:17 pm

Hi!

Did you configure your s9y blog as UTF-8 charset? Which database type are you using, MySQL? Which version?

s9y uses the intenral database search mechanisms, so it might depend on your DB server if it works.

Regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/

hdiaz36
Regular
Posts: 57
Joined: Wed Feb 21, 2007 6:57 pm
Location: China (Yes, really)

Post by hdiaz36 » Tue Nov 27, 2007 5:59 pm

Thank you for your reply.

I think my database is using UTf-8 as the Charset selection.

My database is MySQL 4.1.21 (I think) Sorry, I will contact my host to confirm this.

Does that information help you, or is there something more you need to know?
Image

User avatar
garvinhicking
Core Developer
Posts: 30020
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Post by garvinhicking » Tue Nov 27, 2007 6:06 pm

Hi!

You'll might need to use MySQL 5.1 for full UTF-8 and chinese charset search. Sadly I'm not that experienced with chinese, so I don't have the means to test this. But it should all be only a mysql-charset issue...

Regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/

hdiaz36
Regular
Posts: 57
Joined: Wed Feb 21, 2007 6:57 pm
Location: China (Yes, really)

Post by hdiaz36 » Tue Nov 27, 2007 6:49 pm

Thanks again for your reply.

Haha, and sorry, but I have one more question - is it very easy to update to MySQL 5.1?
Image

User avatar
garvinhicking
Core Developer
Posts: 30020
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Post by garvinhicking » Tue Nov 27, 2007 7:13 pm

Hi!

Usually only your provider can update to MySQL 5.1. It's not very hard, if you already use mysql 4.1 the format is compatible.

REgards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/

Post Reply