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

[Michal Molhanec]

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?