Hello, I've got a table that originally was using UTF8 charset and collation. However, I upgraded one of my applications which is hardcoded to Latin1_General_CI collation in its queries. As a result, I altered the table and any specifically set columns to use Latin1 as the charset and Latin1_General_Ci as the collation. However, whenever I run a query against the table that specifies COLLATE Latin1_General_CI I still receive this error:
COLLATION 'latin1_general_ci' is not valid for CHARACTER SET 'utf8' I'm a bit at wits end as I have also changed the server's default charset/collation to Latin1 and the database's charset/collation to Latin1. I've also tried doing a CREATE TABLE new LIKE old; INSERT INTO new SELECT * FROM old; to attempt to create table fresh. Also, creating a table from scratch defaults to Latin1, but produces the same error when trying to run a query against it that specifies COLLATE. Any help is greatly appreciated. Thank you very much in advance. Best Regards, Jason -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
