List:General Discussion« Previous MessageNext Message »
From:Andrey Kotrekhov Date:November 20 2003 2:48pm
Subject:Re: SQL [Q] how to migrate 4.0 -> 4.1
View as plain text  
Добрый день.

> > 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
Thread
SQL [Q] how to migrate 4.0 -> 4.1Andrey Kotrekhov7 Nov
  • Re: SQL [Q] how to migrate 4.0 -> 4.1Andrey Kotrekhov7 Nov
    • Re: SQL [Q] how to migrate 4.0 -> 4.1Victoria Reznichenko10 Nov
      • Re: SQL [Q] how to migrate 4.0 -> 4.1Andrey Kotrekhov11 Nov
        • Re: SQL [Q] how to migrate 4.0 -> 4.1Victoria Reznichenko19 Nov
          • Re: SQL [Q] how to migrate 4.0 -> 4.1Andrey Kotrekhov20 Nov