Bug #64310 Czech error messages contain garbage
Submitted: 13 Feb 2012 15:31 Modified: 10 May 2012 17:34
Reporter: Honza Horak (OCA) Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Errors Severity:S3 (Non-critical)
Version:5.5.19, 5.5.20 OS:Any (Linux, Windows)
Assigned to: CPU Architecture:Any

[13 Feb 2012 15:31] Honza Horak
When we set mysqld to use Czech language for error messages, we'll get messages with a garbage '-B' before the first non-latin1 character.

How to repeat:
Set "language=czech" in /etc/my.cnf:

1) Try to select a non-existing column:
mysql> select nonexistingcolumn from test.t1;
ERROR 1054 (42S22): Nezn-Bámý sloupec 'nonexistingcolumn' v field list

2) Try to select something when no database has been selected:
mysql> select nonexistingcolumn from t1;
ERROR 1046 (3D000): Nebyla vybr-Bána žádná databáze

See '-B' - that is a garbage, which is contained in all czech messages, usually before the first non-latin1 character.

Suggested fix:
Just remove the garbage from sql/share/errmsg-utf8.txt.
[13 Feb 2012 15:51] Valeriy Kravchuk
What OS and what exact binaries (URL, please) do you use? This is what I see on Mac OS X:

macbook-pro:5.5 openxs$ bin/mysql -uroot test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.5.20-debug Source distribution

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> select nonexisting from mysql.user;
ERROR 1054 (42S22): Neznámý sloupec 'nonexisting' v field list
[13 Feb 2012 15:58] MySQL Verification Team
On Win7 64-bit:

mysql 5.5 >select nonexistingcolumn from t;
ERROR 1054 (42S22): Nezn←-Bámý sloupec 'nonexistingcolumn' v field list
[13 Feb 2012 16:28] Honza Horak
I'm using Fedora 16 and their current rpms:

$ rpm -q mysql mysql-server
[10 May 2012 17:34] Paul DuBois
Noted in 5.6.6 changelog.

Some Czech error messages contained invalid characters.