From: Date: May 3 2005 12:45am Subject: Re: Collation latin1_general_cs List-Archive: http://lists.mysql.com/mysql/183529 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" ; format="flowed" 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" 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" 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