Bug #16573 Syntax error with table names with special character I-acute

• Submitted: 17 Jan 2006 18:34
• Modified: 24 Jan 2006 16:47
• Reporter: Peter Gulutzan
• Status: Not a Bug
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.1.6.alpha-debug
• OS: Linux (SUSE 10.0)
• Assigned to: Alexander Barkov
• CPU Architecture: Any

[17 Jan 2006 18:34] Peter Gulutzan

Description:
I get a syntax error when I try to drop a table whose name
contains the letter I-acute. Things are fine if I use delimiters,
but I don't see where the documentation says that is a
requirement for letters.

How to repeat:
I started mysqld with --default-character-set=utf8 and said "set names utf8" earlier.

mysql> create table _Í (s1 int);
Query OK, 0 rows affected (0.00 sec)

mysql> drop table _Í;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '� at line 1

mysql> drop table `_Í`;
Query OK, 0 rows affected (0.00 sec)

[24 Jan 2006 12:26] Alexander Barkov

It works fine with "mysql --default-character-set=utf8"
i.e. when the client program is started in utf8 mode
from the beginning.

[24 Jan 2006 16:47] Peter Gulutzan

Yes, as my "How to repeat" says, I sleepily used
mysqld --default-character-set=utf8
This is the second time I've wasted Miguel's and
Bar's time on this sort of thing. Sorry.
I've marked it "Not a bug".