like na unique mysql5 (was Re: spatne lcase(concat(..)) v mysql5 - bug?)
Ondrej Koala Vacha
koala na vju.cz
Úterý Únor 14 15:39:13 CET 2006
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
Další informace o konferenci Test