Re: Case insensitive search in utf8 db
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='Γιάννης';
Subject
Views
Written By
Posted
2492
November 29, 2019 01:14PM
Re: Case insensitive search in utf8 db
1065
November 29, 2019 04:31PM
994
November 30, 2019 02:04AM
869
November 30, 2019 10:37AM
906
November 30, 2019 03:46PM
907
November 30, 2019 05:32PM
893
December 01, 2019 02:13AM
751
December 01, 2019 02:00PM
724
December 01, 2019 02:47PM
886
December 01, 2019 03:08PM
926
December 02, 2019 11:34AM
734
December 02, 2019 12:51PM
776
December 02, 2019 01:20PM
760
December 02, 2019 01:40PM
784
December 02, 2019 02:47PM