Re: Case insensitive search in utf8 db

[John Stergiou]

Peter Brawley Wrote:
-------------------------------------------------------
> Can't replicate that problem in 8.0.18, what dies
> this script return on your system?
>
> create schema if not exists cs character
> set='utf8';
> use cs;
> show variables like 'character%';
> show variables like 'collat%';
> set @u='ΓΙΑΝΝΗΣ', @l='Γιαννης', @d='Γιάννης';
> select @u=@l, @u=@d, @l=@d;
>
> drop table if exists cs;
> create table cs( u varchar(32), l varchar(32), d
> varchar(32) ) character set='utf8';
> show create table cs;
> insert into cs values(@u, @l, @d);
> select u=l, u=d, l=d from cs;
> select * from cs where u=@u and l=@l and d=@d;
> select * from cs where u='ΓΙΑΝΝΗΣ' and
> l='Γιαννης'and d='Γιάννης';

You set these 3 words as equal and that's why you have no problem. In my case there are tens of triples of this kind, or even fours of this type with:'ΑΓΓΕΛΟΣ','ΆΓΓΕΛΟΣ','Αγγελος','Άγγελος'. (second and forth words have tonos) That's why I can't set all these "select @u=@l, @u=@d, @l=@d;". In some cases I don't even know what words are in the db.