Bug #25165 False error message,"Identifier too long", when using German umlauts

• Submitted: 19 Dec 2006 9:19
• Modified: 26 Dec 2006 9:56
• Reporter: Heinz Schweitzer (Gold Quality Contributor)
• Status: Duplicate
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 1.2.8
• OS: Windows (XP)
• CPU Architecture: Any

[19 Dec 2006 9:19] Heinz Schweitzer

Description:
False error message,"Identifier too long", when using German umlauts

Changeing/creating a field name of length 64 using only German umlauts like Ä 
yields an sql error dialog.

MySQL-Server-Information
--------------------------------------------------------------------------------
Mit MySQL-Serverinstanz verbunden
  Benutzername:            root
  Hostname:                localhost
  Port:                    3306
--------------------------------------------------------------------------------
Serverinformation
  MySQL-Version:           MySQL 5.0.24a-community-nt via TCP/IP
  Netzwerkname:            localhost
  IP:                      127.0.0.1
--------------------------------------------------------------------------------
Clientinformation
  Version:                 MySQL Client Version 5.1.11
  Netzwerkname:            XXXXXXXXXXX
  IP:                      XXXXXXXXXXX
  Betriebssystem:          Windows XP
  Hardware:                Intel(R) Pentium(R) M processor 1600MHz, 512 MB RAM

How to repeat:
Open  MySQL Administrator 1.2.8 German version
From Kataloge select a schema you can fool around with
In the schema select a table
Create a field with a lenght of 64 do not use umlauts
Create another field of same lentgh sung only umlauts like Ä

If you try to save changes you will get an error dialog like 
in screen shot l1

[19 Dec 2006 9:19] Heinz Schweitzer

l1

Attachment: shot_2.jpg (image/jpeg, text), 142.49 KiB.

[26 Dec 2006 9:56] Sveta Smirnova

Thank you for the report.

But cause is not MySQL Administrator, but server behaviour.

See also Bug #21432