Добрый день. > > 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 > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ 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/[EMAIL PROTECTED] > > Best regards. _______________________________________ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport тел. +380 562 34-00-44 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]