Добрый день.
> > Thank you. But what is about binary fields?
> > When I start mysqld-4.0.. field in table are char(x) binary.
> > But when I start mysql-4.1.0 in the same table the same field is not
> > binary.
> > Is this bug?
>
> Nope. From the v4.1 BINARY means that no collation is applicable to the column.
I understand this and I want this.
But my binary fields under 4.1.0 loss binary flag.
But under 4.0.12 they have it (the fields in same tables).
I head the 4.1.1 version will fix this
>
> > Or is there right way to restore binary flag on field.
>
> Use collation with _bin at the end of collation name.
It is fine for new tables, but I say about tables created under 4.0.X
and after migration to 4.1.0 they loss binary flags on their fields.
>
>
> --
> For technical support contracts, goto https://order.mysql.com/?ref=ensita
> This email is sponsored by Ensita.net http://www.ensita.net/
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Victoria Reznichenko
> / /|_/ / // /\ \/ /_/ / /__ Victoria.Reznichenko@stripped
> /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
> <___/ www.mysql.com
>
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>
>
Best regards.
_______________________________________
Andrey Kotrekhov kota@stripped
ISP Alkar Teleport
тел. +380 562 34-00-44