I have a machine with Debian 6.0.x and MySQL Server version: 5.1.66-0 + squeeze1 (Debian).
If I configure my machine with it_IT@EURO instead of en_US.UTF-8 Mysql is not happy, eg a table control / optimization tells me: mysqlcheck: Unknown OS character set 'ISO-8859-15'. mysqlcheck: Switching to the default character set 'latin1'.
The warning message is simple, Mysql suggests to change the character set etc.
The thing I do not understand is what effect it has on the database? If I change the character set in a Mysql config, means that I will convert all database? I would avoid this.
I just want to set it_IT@EURO and leave and Mysql database as they are.
I have configured it_IT.UFT-8 and I have no problems, but it is ugly! All of the words with the accent in my language are crippled.
What would be an elegant solution? Can someone enlighten me?