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" <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> 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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
