Blog
Configuring MySQL for UTF-8
If you want to run MySQL primarily using UTF-8 then the configuration file my.cnf should contain the following directives:
#128003 • 02/27/2011 5:11pm by Martin Brampton • Vote cast: Up votes (26) Down votes (25)
Checking for problems in my.cnf
If you want to check for errors in the MySQL configuration file my.conf you can start the MySQL daemon from a command line with helpful parameters:
mysqld --help
will provide a lot of information about the available parameters.
#128002 • 02/27/2011 5:07pm by Martin Brampton • Vote: Up votes (26) Down votes (20)
How to change collation for all columns in a MySQL table
In principle, it is possible to change the character set for all the fields in a table. But this can give problems and needs to be tackled with care. The table should certainly be backed up before attempting the change.
#128001 • 02/27/2011 5:01pm by Martin Brampton • Vote: Up votes (24) Down votes (21)
