Bug #1406 Tablename in Errormessage not in default characterset
Submitted: 25 Sep 2003 23:32 Modified: 21 Jun 2010 7:45
Reporter: Georg Richter Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Charsets Severity:S3 (Non-critical)
Version:4.1, 5.0, 5.1 OS:Any
Assigned to: Alexander Barkov CPU Architecture:Any

[25 Sep 2003 23:32] Georg Richter
If you specify an incorrect tablename, errormessage shows the tablename in utf8 

How to repeat:
mysql> \s 
Client characterset:    latin1_swedish_ci 
Server characterset:    latin1_swedish_ci 
mysql> drop table ä; 
ERROR 1051 (42S02): Unknown table 'Ã?' 
Tablename was german A-Umlaut (&auml;) if you can't read it.
[18 Mar 2004 22:51] Alexander Barkov
Another related bug report:

[24 Sep 2004 14:28] Alexander Barkov
We won't fix it in 4.1. It will be fixed int either 5.0 or 5.1.
[2 May 2005 5:39] Alexander Barkov
See also:

[28 Mar 2006 11:18] Alexander Barkov
See also:
[30 May 2006 5:14] Alexander Barkov
See also
[4 Sep 2007 17:39] Alexander Barkov
See also http://bugs.mysql.com/bug.php?id=29440
[31 Jan 2008 12:04] Susanne Ebrecht
This is still in bk tree. By using character_set_client=latin1 and terminal encoding=ISO-8859-15

mysql-5.0-bk> select version()\G
*************************** 1. row ***************************
version(): 5.0.56-debug

mysql-5.1-bk> select version()\G
*************************** 1. row ***************************
version(): 5.1.24-rc-debug

mysql> drop table ä;
ERROR 1051 (42S02): Unknown table 'À'

switching terminal encoding to utf8 and using:
mysql> set names utf8;
mysql> drop table ä;
ERROR 1051 (42S02): Unknown table 'ä'
[19 Jun 2008 10:32] Konstantin Osipov
Suggested fix:
 - recode the error messages to utf-8
 - conver the error to character_set_results when sending to the client.
[19 Jun 2008 10:51] Konstantin Osipov
The impact of this bug is increased when WL#2110 "SIGNAL" is implemented.
SIGNAL messages will be in utf8, and if character_set_results is different
from utf8, clients won't be able to read it.
[31 Jul 2008 8:44] Alexander Barkov
See also: 
[9 Oct 2008 13:42] Susanne Ebrecht
Bug #39949 was set as duplicate of this bug here.
[12 May 2009 2:46] Mulyadi Pasaribu
Hm... Many report about the Tablename in Errormessage not in default characterset.

[21 Jun 2010 7:44] Alexander Barkov
This bug was fixed in 5.4 

For details see: