Serendipity Forums

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

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

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?

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

Thanks again for your reply.

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

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