Bug #1406 Tablename in Errormessage not in default characterset
Submitted: 26 Sep 2003 1:32 Modified: 20 Sep 2006 16:58
Reporter: Georg Richter
Status: Verified
Category:Server: Charsets Severity:S3 (Non-critical)
Version:4.1, 5.0, 5.1 OS:Any
Assigned to: Alexander Barkov Target Version:6.1
Triage: Triaged: D3 (Medium)

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

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

  http://bugs.mysql.com/bug.php?id=2804&edit=1
[24 Sep 2004 16: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 7:39] Alexander Barkov 
See also:

http://bugs.mysql.com/bug.php?id=10094
[28 Mar 2006 13:18] Alexander Barkov 
See also:
http://bugs.mysql.com/bug.php?id=14602
http://bugs.mysql.com/bug.php?id=16774
[30 May 2006 7:14] Alexander Barkov 
See also
http://bugs.mysql.com/bug.php?id=20027
[4 Sep 2007 19:39] Alexander Barkov 
See also http://bugs.mysql.com/bug.php?id=29440
[31 Jan 2008 13: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 12: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 12: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 10:44] Alexander Barkov 
See also: 
http://bugs.mysql.com/bug.php?id=27988
[9 Oct 2008 15:42] Susanne Ebrecht 
Bug #39949 was set as duplicate of this bug here.
[12 May 4:46] Mulyadi Pasaribu 
Hm... Many report about the Tablename in Errormessage not in default characterset.

http://computersmagazines.info/