Hello.
> | latin1_general_cs | latin1 | 49 | | | 0 | You have this collation installed. The output from SHOW COLLATION includes all available character sets. Andre Matos <[EMAIL PROTECTED]> wrote: > Hi List, > > I was checking the list of collations for a character set "latin" that I > have in my MySQL version 4.1.10-standard running on Mac OS X 10.4. > > The list that I have, bellow, does not include "latin1_general_cs". What > will happen if I force to use it when I create a database, tables and > fields? Will it work or not? > > > mysql> SHOW COLLATION LIKE 'latin1%'; > +-------------------+---------+----+---------+----------+---------+ > | Collation | Charset | Id | Default | Compiled | Sortlen | > +-------------------+---------+----+---------+----------+---------+ > | latin1_german1_ci | latin1 | 5 | | | 0 | > | latin1_swedish_ci | latin1 | 8 | Yes | Yes | 1 | > | latin1_danish_ci | latin1 | 15 | | | 0 | > | latin1_german2_ci | latin1 | 31 | | Yes | 2 | > | latin1_bin | latin1 | 47 | | Yes | 1 | > | latin1_general_ci | latin1 | 48 | | | 0 | > | latin1_general_cs | latin1 | 49 | | | 0 | > | latin1_spanish_ci | latin1 | 94 | | | 0 | > +-------------------+---------+----+---------+----------+---------+ > > Thanks for any help. > > Andre > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [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]