MySQL Forums
Forum List  »  General

collations and charsets
Posted by: Venca
Date: December 05, 2004 10:55AM

I have an interesting problem, I moved to Apache 2.0.52, PHP 5.02 and MySQL 4.1.17, of course :)

I have this query

SELECT COUNT(id) FROM users WHERE username = 'admin' AND password = SHA1('admin')

it runs on Query Browser correctly, but in a php script I get this error

Illegal mix of collations (cp1250_czech_cs,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='

These are variables on my MySQL server

character_set_client utf8
character_set_connection cp1250
character_set_database cp1250
character_set_results utf8
character_set_server cp1250
character_set_system utf8
collation_connection cp1250_czech_cs
collation_database cp1250_czech_cs
collation_server cp1250_czech_cs

OS is WinXP SP2

Hope for a solution :D

Options: ReplyQuote

Written By
collations and charsets
December 05, 2004 10:55AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.