michaelsanford
Translator, Web Developer
I've just noticed the COLLATE character set column attribute in MySQL 4.1.6 ; what is it used for exactly ?
I've also noticed that phpMyAdmin 2.6.0 doesn't let you alter the collation of a table that already exists, but you can alter the collation of individual columns.
Basically, I want to know if using the default, latin1_swedish_ci, is going to affect my scripts in any way... I've determined that the _ci and _cs suffixes mean case in/sensitive, which looks like it could be kind of important.
FYI in a kind of obsessive-compulsive way I've set all my new columns to utf8_unicode_ci.
From the documentation ( http://dev.mysql.com/doc/mysql/en/Charset-general.html ) the purpose of collation seems more logical to reside in a statement (like a JOIN) than in the column itself, hence my question.
I've also noticed that phpMyAdmin 2.6.0 doesn't let you alter the collation of a table that already exists, but you can alter the collation of individual columns.
Basically, I want to know if using the default, latin1_swedish_ci, is going to affect my scripts in any way... I've determined that the _ci and _cs suffixes mean case in/sensitive, which looks like it could be kind of important.
FYI in a kind of obsessive-compulsive way I've set all my new columns to utf8_unicode_ci.
From the documentation ( http://dev.mysql.com/doc/mysql/en/Charset-general.html ) the purpose of collation seems more logical to reside in a statement (like a JOIN) than in the column itself, hence my question.