Re: Collation latin1_general_cs
Hello. | latin1_general_cs | latin1 | 49 | | | 0 | You have this collation installed. The output from SHOW COLLATION includes all available character sets. Andre Matos [EMAIL PROTECTED] 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. The list that I have, bellow, 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? 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 | +---+-++-+--+-+ Thanks for any help. Andre -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Collation latin1_general_cs
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? 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 | +---+-++-+--+-+ Thanks for any help. Andre -- Andre Matos [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Collation latin1_general_cs
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]
Re: Collation latin1_general_cs
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? 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 | +---+-++-+--+-+ -- Andre Matos [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Collation latin1_general_cs
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]
Re: Collation latin1_general_cs
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 [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 | +---+-++-+--+-+ -- Andre Matos [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Collation latin1_general_cs
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]
Collation latin1_general_cs
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. The list that I have, bellow, 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? 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 | +---+-++-+--+-+ Thanks for any help. Andre -- Andre Matos [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]