MySQL charsets and collations
 

Hi all,

I've just brought up a shiny new CentOS box (v5.1) and all's well.

I needed to install mysql-server and did so via yum. Additionally, I put on phpmyamin for ease of use in manipulating tables.

When I go to create a database and add tables, all's well, but the default character set is latin1 for which the default collation is latin1_swedish_ci.

I've googled and read and read more. Is there anyone who can show me a sample of using the my.cnf file in /etc to default this to latin2 and latin2_general_ci, or any flavor of generic utf8?

Thanks in advance,
-Ray

You can set those when starting the server. http://dev.mysql.com/doc/refman/5.1/...et-server.html