MySQL Forums
Forum List  »  Newbie

Solution for Unknown OS character set 'ISO-8859-15'
Posted by: Net Vicious
Date: November 06, 2012 03:06AM

If you get this error:

/usr/bin/mysql: Switching to the default character set 'latin1'.
/usr/bin/mysql: Unknown OS character set 'ISO-8859-15'.

Surely you should have on the locales something like:

# locale

The problem here it's the @euro part, because it's an alias of ISO-8859-15. MySQL doesn't knows it and shows the error.

One solution should be changing the locales of the entire system to utf8 (in my case es_ES@utf8) or ISO-8859-1 (in my case es_ES@ISO-8859-1), check also de locales.alias file because you should have on it the ISO-8859-15 problem there.

Other solution could be editing the startup script of mysqld (/etc/init.d/mysql or /etc/rcX.d/mysql) writing on the top of the script this:

export LANG=es_ES.ISO-8859-1
export LC_ALL=es_ES.ISO-8859-1

Change the es_ES with your desired language.

With this we will only change the locales for the mysql process and we won't see the ugly error lines in our logs/mails, ....


Options: ReplyQuote

Written By
Solution for Unknown OS character set 'ISO-8859-15'
November 06, 2012 03:06AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.