like na unique mysql5 (was Re: spatne lcase(concat(..)) v mysql5 - bug?)

[Ondrej Koala Vacha]

On Tue, 14 Feb 2006, Michal Molhanec wrote:

> Ondrej Koala Vacha napsal(a):
> > ---------------------------------
> > create table a (
> > id 	int(5) not null,    tt	char(255) not null,
> > unique (tt)
> > ) ;
> > 
> > insert into a values (1,'Aa');
> > insert into a values (2,'Aas');
> > 
> > 
> > select * from a where tt='Aa';             <------- najde
> > select * from a where tt like 'Aa%';       <------- najde jen Aas, tedy
> > nenajde Aa
> > select * from a where tt like 'Aa';        <------- nenajde
> > ------------------------------------
> > 
> > 
> > Muzu poprosit o komentar, resp. nakopnuti?
> 
> jake ma sloupec tt collation?
> 



latin2_czech_cs, ale odzkouseno ze s utf8_czech_ci to nedela
--
Ondrej Koala Vacha