MySQL Bugs: #64310: Czech error messages contain garbage

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:	None
Category:	MySQL Server: Errors	Severity:	S3 (Non-critical)
Version:	5.5.19, 5.5.20	OS:	Any (Linux, Windows)
Assigned to:		CPU Architecture:	Any

Description:
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:
[myslqd]
language=czech

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.

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
owners.

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

On Win7 64-bit:

mysql 5.5 >select nonexistingcolumn from t;
ERROR 1054 (42S22): Nezn←-Bámý sloupec 'nonexistingcolumn' v field list

I'm using Fedora 16 and their current rpms:

$ rpm -q mysql mysql-server
mysql-5.5.20-1.fc16.x86_64
mysql-server-5.5.20-1.fc16.x86_64

Noted in 5.6.6 changelog.

Some Czech error messages contained invalid characters.