Why does MySQL use latin1_swedish_ci as the default?

Why does MySQL use latin1_swedish_ci as the default?

Does anyone know why latin1_swedish is the default for MySQL. It would seem to me that UTF-8 would be more compatible right? Defaults are usually chosen because they are the best universal choice, bu…


mysql Illegal mix of collations in stored procedure

my stored procedure in MySQL fails with Mysql::Error: Illegal mix of collations(utf8_general_ci,IMPLICIT) and(utf8_unicode_ci,IMPLICIT) for operation '='. The procedure fails when in SELECT clause i…


MySQL Collation: latin1_swedish_ci Vs utf8_general_ci

What should I set for Collation when creating tables in MySQL: latin1_swedish_ci or utf8_general_ci What is Collation anyway? I have been using latin1_swedish_ci, would it cause any problems?…


mysql Change server variable character_set_server

I want to change the mysql server variable character_set_server to utf8. I have googled on this but can't seem to find the information I'm looking for or the instructions don't match. It seems I need…


Illegal mix of collations(utf8_general_ci,IMPLICIT) and(utf8_unicode_ci,IMPLICIT) within stored procedure

All the tables are in utf_unicode_ci. I've done this to check SELECT table_schema, table_name, column_name, character_set_name, collation_name FROM information_schema.columns WHERE collation_nam…


Illegal mix of collations(utf8_general_ci,IMPLICIT) and(utf8_unicode_ci,IMPLICIT) for operation '=' in MySQL Stored Procedure

I checked the database table and found it was in latin1_swedish_ci so i've changed it to utf8_general_ci then I changed the collation from latin1_swedish_ci to utf8_general_ci for all the fields. Sti…


mysql utf8_bin vs. utf_unicode_ci

My table Website Website_Name//column name Google Facebook Twitter Orkut Frype Skype Yahoo Wikipedia I i use utf8_bin collation then my query to search wikipedia in Website is Select Website_Name fro…


MySQL Case Insensitive but Accent Sensitive UTF8 Unique Key

I know there are a lot of similar questions on SF, but I think mine is different enough to warrant a new question. I have a table that has a single column as utf8 with utf8_unicode_ci. It also has a…



sql server Is there such thing as 'Unicode collation'?

Or if it does not, then what is actually a Sql Server collation? Maybe my understanding of collation(as a concept) is wrong. I do not wish to specify my collation to greek or icelandic or even wester…


mysql Illegal mix of collations(utf8_unicode_ci,IMPLICIT) and(utf8_general_ci,IMPLICIT) for operation '='

Error msg on MySql: Illegal mix of collations(utf8_unicode_ci,IMPLICIT) and(utf8_general_ci,IMPLICIT) for operation '=' I have gone through several other posts and was not able to solve this problem…




mysql collation utf8 utf8_unicode_ci set character for collations operation mix