Re: Collation latin1_general_cs

[Paul DuBois]

At 15:28 -0400 5/2/05, Andre Matos 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.
>
>Below is the that I have and 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?

I don't understand what you mean by stating that the list doesn't
include latin1_general_cs.  It does appear in the list.

>
>
>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 |
>+-------------------+---------+----+---------+----------+---------+


-- 
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com