Collation latin1_general_cs

[Andre Matos]

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

-- 
Andre Matos
amatos@stripped