Bug #29440 Only questions marks in German error messages using utf8
Submitted: 29 Jun 2007 8:30 Modified: 4 Sep 2007 17:39
Reporter: Susanne Ebrecht Email Updates:
Status: Duplicate Impact on me:
Category:MySQL Server: Charsets Severity:S2 (Serious)
Version:5.1 and lower OS:Any
Assigned to: Assigned Account CPU Architecture:Any

[29 Jun 2007 8:30] Susanne Ebrecht
Hi all,

System: FreeBSD, Ubuntu both 64bit, but I suppose this behaviour will be on all Unix systems. Also I suppose, that it will occur with other languages than German.

MySQL compiled with utf8 support.

No other language support besides utf8 on the systems installed.

Setting language to German to get German system/error message.

Open the cli:

First shock: character_set_client is latin1.

Ok, then it is logical, that the error messages are only question marks outside the 7-bit-ascii-sector.

Changing character_set for client on different ways. I tried: set names utf8,
set character_set_client=utf8 and I started: mysql --default_character_set=utf8

all results were the same: character_set_client now is utf8.

But my error message are still only question marks outside the 7-bit-ascii-sector.

Also I tried to get an error message with non-7-bit characters on my console (locale is utf8, I used SH, KSH and BASH). It was the same result, signs outside 7-bit are just questionmarks and the messages are not really readable.

It seems, that the error messages wouldn't be matched to the client encoding.

All works very fine on all my only-iso-systems.

How to repeat:
You need an utf8 system.
Switch the language for the messages to German.
Open the cli and make an update on a table or something else, where you will get a message that uses German letters.

Suggested fix:
I suppose, the encoding between messages and client will not handled.
[29 Jun 2007 9:16] Sveta Smirnova
Thank you for the report.

Verified as described.
[4 Sep 2007 17:39] Alexander Barkov
This is a duplicate for bug#1406