Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question
    
Have you tried to change the character_set_client and ` character_set_connection` options in your my.cnf (or whatever debian uses)? –  NickW Mar 14 '13 at 13:59
    
not because I do not know what effect it would have on the database, I read on the internet that the database is better that they are encoded in UTF-8. –  Max121 Mar 14 '13 at 17:38
    
Si, ma questi opzioni cambiano le carattere con cui il cliente vede la data, ma non la db se stesso. They're just options for the client connections, UTF-8 is fairly universal, but as often as not, it isn't perfect for languages with characters you don't find in english.. –  NickW Mar 14 '13 at 17:44

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.