Edit File: ctype_latin2_ch.result
drop table if exists t1; set names latin2; select 'A' = 'a' collate latin2_czech_cs; 'A' = 'a' collate latin2_czech_cs 0 create table t1 ( id int(5) not null, tt char(255) not null ) character set latin2 collate latin2_czech_cs; insert into t1 values (1,'Aa'); insert into t1 values (2,'Aas'); alter table t1 add primary key aaa(tt); select * from t1 where tt like 'Aa%'; id tt 1 Aa 2 Aas select * from t1 ignore index (primary) where tt like 'Aa%'; id tt 1 Aa 2 Aas select * from t1 where tt like '%Aa%'; id tt 1 Aa 2 Aas select * from t1 where tt like 'AA%'; id tt select * from t1 ignore index (primary) where tt like 'AA%'; id tt select * from t1 where tt like '%AA%'; id tt drop table t1;
Back to File Manager