Bug #46619 mysql client programs complain about default Solaris locale
Submitted: 9 Aug 2009 11:58 Modified: 12 Nov 2009 3:40
Reporter: Elena Stepanova Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Charsets Severity:S3 (Non-critical)
Version:5.4.4-alpha OS:Solaris
Assigned to: Alexander Barkov CPU Architecture:Any
Tags: regression

[9 Aug 2009 11:58] Elena Stepanova
Description:
On Solaris systems with default "C" locale mysql client programs throw warnings on startup (e.g. mysql, mysqladmin):

Unknown OS character set '646'.
Switching to the default character set 'latin1'.

---------------------
locale
LANG=
LC_CTYPE="C"
LC_NUMERIC="C"
LC_TIME="C"
LC_COLLATE="C"
LC_MONETARY="C"
LC_MESSAGES="C"
LC_ALL=

How to repeat:
- set locale to default;
- start MySQL server;
- connect to the server using mysql or mysqladmin.

Suggested fix:
WL#1349 does not say anything specifically about "C" locale, but apparently Solaris defaults should have mappings in MySQL universe.
[10 Aug 2009 5:14] Sveta Smirnova
Thank you for the report.

Verified as described. Version 5.1 is not affected.
[15 Oct 2009 8:43] Alexander Barkov
A similar problem happens on HPUX machines:

Unknown OS character set 'roman8'.
Switching to the default character set 'latin1'.
[3 Nov 2009 11:53] Alexander Barkov
Pushed into mysql-5.5.0-beta, as a part of backport of WL#1349.
Pushed into mysql-6.0.14-beta.
[12 Nov 2009 3:40] Paul Dubois
Noted in 5.5.0, 6.0.14 changelogs.

On Solaris and HP-UX systems where the environment was set to the
default C locale, MySQL client programs issued an "Unknown OS
character set" error.