On Friday, November 18, 2011 at 03:31:44 UTC, martin.mueller@stripped confabulated:
> Is it possible to make utf8 the default for all databases and transactions
> in a MySQL installation?
> The current default is Latin1. There is a suggestion on the Web to edit
> the my.cnf file as follows
> init_connect=’SET collation_connection = utf8_general_ci’
> init_connect=’SET NAMES utf8′
> On a Mac with MySQL 5.5.17 this produces the error
> [ERROR] /usr/local/mysql/bin/mysqld: unknown variable
> The Reference Manual is very tortuous but lacks instructions that are
> clear to a not very technical user.
The above link says default-character-set is depreciated and you should
be using character-set-server. It also states default-character-set
was removed in v5.5.3.
You should be able to remove the option.
There are 10 kinds of people in the world... Those who understand
binary, and those who don't.