Hello.
> | latin1_general_cs | latin1 | 49 | | | 0 |
You have this collation installed. The output from SHOW COLLATION includes all
available character sets.
Andre Matos <amatos@stripped> 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
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
