Re: Collation latin1_general_cs

[Andre Matos]

Ok Paul. 

Do you have any idea why phpMyAdmin removed the "latin1_general_cs" from the
collation pop-up list?

I have the same problem like this one (except that I am using Mac OS X):
http://forums.mysql.com/read.php?11,21462,21462

I looked at the release notes for the version 2.6.2 (it was working up to
version 2.6.1-pl3), and I found this: "Do not offer unavailable collations".

Does this means that if the MySQL is not compiled with the
"latin1_general_cs" it will not work even if MySQL loaded it at runtime?

Andre


On 5/2/05 4:44 PM, "Paul DuBois" <paul@stripped> wrote:

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

-- 
Andre Matos
amatos@stripped