Andrey Kotrekhov <[EMAIL PROTECTED]> wrote: >> Andrey Kotrekhov <[EMAIL PROTECTED]> wrote: >> > Hi, All. >> > Other question is: >> > Can I create case sensitive field with right ordering of national >> > characters. >> > >> >> Take a look at collation name: "ci" at the end of the collation name mean= > s case insensitive, "cs" - case sensitive, "bin" - binary: >> =09http://www.mysql.com/doc/en/Charset-MySQL.html >> > > 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. > Or is there right way to restore binary flag on field. Use collation with _bin at the end of collation name. -- 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]
