Bug #1406 Tablename in Errormessage not in default characterset

• Submitted: 25 Sep 2003 23:32
• Modified: 21 Jun 2010 7:45
• Reporter: Georg Richter
• Status: Closed
• 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

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 22:51] Alexander Barkov

Another related bug report:

  http://bugs.mysql.com/bug.php?id=2804&edit=1

[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:

http://bugs.mysql.com/bug.php?id=10094

[28 Mar 2006 11:18] Alexander Barkov

See also:
http://bugs.mysql.com/bug.php?id=14602
http://bugs.mysql.com/bug.php?id=16774

[30 May 2006 5:14] Alexander Barkov

See also
http://bugs.mysql.com/bug.php?id=20027

[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: 
http://bugs.mysql.com/bug.php?id=27988

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

http://computersmagazines.info/

[21 Jun 2010 7:44] Alexander Barkov

This bug was fixed in 5.4 

For details see:
http://forge.mysql.com/worklog/task.php?id=751