| 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 | |
[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_... collations
Description: 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' ".