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