Re: Collation latin1_general_cs

[Paul DuBois]

At 17:01 -0400 5/2/05, Andre Matos wrote:
>Ok Paul.
>
>Do you have any idea why phpMyAdmin removed the "latin1_general_cs" from the
>collation pop-up list?

No.

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

I don't know what phpMyAdmin means by "unavailable collations".  But
if SHOW COLLATION shows a collation, it's available.


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

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