Your browser (Internet Explorer 6) is out of date. It has known security flaws and may not display all features of this and other websites. Learn how to update your browser.
X
Post

Unicode searches in MySQL

MySQL usually sucks for Unicode searches. They have tuned their partial text search for 4 character words or more – certainly, not what the doctor ordered when it comes to the normally 2 or 3 character asiatic language set. However I ran into something interesting today.
SELECT *
FROM `ads`
WHERE `description` LIKE ‘%経%’
LIMIT 0 , 30

This seems to work perfectly. Hrm. I just need to fix the damn classified section and I’m set.

January 31, 2006