[PHP-DB] collation problem in mysql
hi all, i have a problem using mysql, when i execute this sql : SELECT phplib_id FROM subscriber WHERE user_id = 'admin' AND password = 'hello' i got the following error message : Illegal mix of collation (latin1_swedish_ci, IMPLICIT) and (utf_general_ci, COERCIBLE) for operation '=' i have read through the mysql doc but still i had a confusion on how to solve the problem. Is there any suggestion from any of you on how to solve this problem??? -- Ade Anom A [http://www.a3rex.info] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] collation problem in mysql
You're sending the query in a different encoding than the server is expecting it looks like, or perhaps somehow mixing encodings somehow? Although that doesn't make sense. I'd check the default PHP encoding versus what mysql is set up for. -Micah On Friday 21 October 2005 1:07 am, Anom wrote: hi all, i have a problem using mysql, when i execute this sql : SELECT phplib_id FROM subscriber WHERE user_id = 'admin' AND password = 'hello' i got the following error message : Illegal mix of collation (latin1_swedish_ci, IMPLICIT) and (utf_general_ci, COERCIBLE) for operation '=' i have read through the mysql doc but still i had a confusion on how to solve the problem. Is there any suggestion from any of you on how to solve this problem??? -- Ade Anom A [http://www.a3rex.info] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Collation?
language character type for the column. read the manual for more details bastien From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] Collation? Date: Tue, 2 Aug 2005 22:39:38 -0700 There's a new thing in my SQL db, but I don't know what it is. Using phpMyAdmin to view the structure of my table. A column called: Collation It has a value of latin1_swedish_ci for most of the fields. All but date fields. Anyone know what this is? Andrew Darrow Kronos1 Productions www.pudlz.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Collation?
I've read a bit more about this and just want to make sure that I'm correct in my thinking. Since the value of the field is latin1_swedish_ci it's expecting something in the swedish language. My DB will be storying information in a strings of mostly english, but I don't see why it shouldn't work with other languages I should set it to utf8_bin. Right? Andrew Darrow Kronos1 Productions www.pudlz.com - Original Message - From: Bastien Koert [EMAIL PROTECTED] To: [EMAIL PROTECTED]; php-db@lists.php.net Sent: Wednesday, August 03, 2005 6:12 AM Subject: RE: [PHP-DB] Collation? language character type for the column. read the manual for more details bastien From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] Collation? Date: Tue, 2 Aug 2005 22:39:38 -0700 There's a new thing in my SQL db, but I don't know what it is. Using phpMyAdmin to view the structure of my table. A column called: Collation It has a value of latin1_swedish_ci for most of the fields. All but date fields. Anyone know what this is? Andrew Darrow Kronos1 Productions www.pudlz.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.9.9/62 - Release Date: 8/2/2005 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Collation?
There's a new thing in my SQL db, but I don't know what it is. Using phpMyAdmin to view the structure of my table. A column called: Collation It has a value of latin1_swedish_ci for most of the fields. All but date fields. Anyone know what this is? Andrew Darrow Kronos1 Productions www.pudlz.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
