Bug #9590 COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'latin1'
Submitted: 3 Apr 2005 8:24 Modified: 5 Apr 2005 14:40
Reporter: naeem irshad Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Websites: bugs.mysql.com Severity:S2 (Serious)
Version:> 4.1 OS:Linux (linux)
Assigned to: CPU Architecture:Any

[3 Apr 2005 8:24] naeem irshad
i am subscribe to a new web hosting server. when i submit query, i received error "COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'latin1' ". What should i do to get rid of it. Its urgent, please help me.

How to repeat:
SELECT user_id, user_first_name, user_last_name, user_type_id, date_format(last_login,'%e-%m-%y %h:%i %p') as last1 FROM users WHERE user_login = 'sa' AND user_password = password('1') collate utf8_general_ci AND user_status = 'ACTIVE'

when i run this query i got an error of "COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'latin1' ".
[5 Apr 2005 14:40] Hartmut Holzgraefe
We're sorry, but the bug system is not the appropriate forum for 
asking help on using MySQL products. Your problem is not the result 
of a bug.

Support on using our products is available both free in our forums
at http://forums.mysql.com and for a reasonable fee direct from our
skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.

Additional info:

hint: collations are only valid for a single character set,
the password field seems to be using latin1 as charset here,
so only latin1_... collations are valid for it but not e.g. utf8_...