Re: case insensitive LIKE with utf8 (multibyte)

2003-06-18 Thread Tibor Simko
On Fri, 30 May 2003, Jeremy March wrote: > The problem is that querying with a LIKE expression is treated case > and accent sensitive. [...] Has anyone else experienced this with > multibyte utf8? Yes. mysql-standard-4.1.0-alpha-pc-linux-i686 running with --default-character-set=utf8 gives me:

case insensitive LIKE with utf8 (multibyte)

2003-05-30 Thread Jeremy March
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 use