Re: [PHP-DB] collation problem in mysql

2005-10-21 Thread Micah Stevens
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 wro

Re: [PHP-DB] Remove MySQL Server

2005-10-21 Thread Shahmat Dahlan
You can also run this, that is if you haven't manually removed your mysql installation directory c:\>mysqld --remove ,where is usually MySQL Unnawut Leepaisalsuwanna wrote: 1. Run Regedit or regedt32. 2. Find the registry entry: |HKEY_LOCAL_MACHINE/SYSTEM/CurrentContro

[PHP-DB] collation problem in mysql

2005-10-21 Thread Anom
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 rea