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
Quicksearch using Chinese not working?
-
- Core Developer
- Posts: 30022
- Joined: Tue Sep 16, 2003 9:45 pm
- Location: Cologne, Germany
- Contact:
Re: Quicksearch using Chinese not working?
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
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/
# 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/
-
- Core Developer
- Posts: 30022
- Joined: Tue Sep 16, 2003 9:45 pm
- Location: Cologne, Germany
- Contact:
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
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/
# 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/
-
- Core Developer
- Posts: 30022
- Joined: Tue Sep 16, 2003 9:45 pm
- Location: Cologne, Germany
- Contact:
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
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/
# 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/