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
• Status: Closed
• 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.