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) Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:1.2.8 OS:Microsoft Windows (XP)
Assigned to: 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