Quicksearch using Chinese not working?

[hdiaz36]

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

[garvinhicking]

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

[hdiaz36]

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?

[garvinhicking]

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

[hdiaz36]

Thanks again for your reply.

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

[garvinhicking]

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