Re: Collation latin1_general_cs

[Paul DuBois]

At 16:15 -0400 5/2/05, Andre Matos wrote:
>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?

Yes.  Some character set information is loaded at runtime.


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


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