I'm working with the Greek unicode range on mysql 4.1, redhat 8.0. The problem is that querying with a LIKE expression is treated case and accent sensitive. The sort order and comparing with "=" do work correctly (case and accent insensitive). I noticed in the source code that the utf8 cs uses the "simple" LIKE function--could that be the problem? LIKE works correctly (case insensitive) for the Latin unicode range, I assume because it isn't multibyte.
Has anyone else experienced this with multibyte utf8? Thanks, Jeremy March