You're right. The LIKE comparison only works properly with the Latin
letters in utf8. MySQL hasn't yet fixed it to work with the rest of Unicode
yet. I believe there is a valid LIKE comparison for ucs2. From what I
remember, however, it has problems too if you start putting wildcards at the
beginning or middle of strings though. I've been meaning to post a
repeatable bug report on this for awhile. Within the next day or so.
Hopefully utf8 will get a proper LIKE function before they freeze the 4.1
features--or maybe that would still be a bug and not a new feature. Try
experimenting with the LIKE in ucs2 with multiple wildcards or with them in
the beginning or middle of strings. I'd like to get some independent
confirmation that the problem isn't just me.
best,
Jeremy
_________________________________________________________________
Have fun customizing MSN Messenger — learn how here!
http://www.msnmessenger-download.com/tracking/reach_customize
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
