Hi Paul,
It does appear in the list, but there is no "Yes" in the column "Compiled"
and that's why my concern. I am using the Collation "latin1_general_cs"
since I moved from version 3.x to 4.1.10. Is it really working without
compiled?
Andre
On 5/2/05 4:04 PM, "Paul DuBois" <paul@stripped> wrote:
> 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 |
>> +-------------------+---------+----+---------+----------+---------+
>
--
Andre Matos
amatos@stripped
