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:
$ cat test1.sql
create table if not exists test1 (name text);
truncate table test1;
insert into test1 values ("amélie"),("amelie");
select count(*) from test1 where name="amelie";
select count(*) from test1 where name like "amelie";
drop table test1;
$ mysql -B -u foo -p test < test1.sql
Enter password: *********
count(*)
2
count(*)
1
Is this the expected behaviour?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
