#4380 (ok 4.2.1) Cannot display table structure with enums containing special characters

[Marc]

create the following table:
CREATE TABLE rdShopItems (
ID int(10) unsigned NOT NULL AUTO_INCREMENT,
GefahrGesund enum('','Sehr giftig','Giftig','Gesundheitsschädlich') COLLATE latin1_german1_ci NOT NULL,
GefahrReiz enum('','Ätzend','Reizend') COLLATE latin1_german1_ci NOT NULL,
GefahrUmwelt enum('','Umweltgefährlich') COLLATE latin1_german1_ci NOT NULL,
PRIMARY KEY (ID)
) ENGINE=MyISAM

table creation is correct, if you try to select the table you get "Error, Code 200, Ok".

[Marc Delisle]

Confirmed; produces a js error. Report transmitted to the dev team:
https://reports.phpmyadmin.net/reports/view/2384

[Hugues Peccatte]

Hi,

Here is a more simple "CREATE TABLE" to understand what is the issue:
CREATE TABLE f4380 (
field enum('0123456789012345678901234567890123456789012ä')
) ENGINE=MyISAM;

The issue is due to the ä (or any character of extend ASCII codes: http://www.asciitable.com/) in 50th position.
If this character is in 49th position, there won't be any error neither in 51th position.

I hope it can help…

[Hugues Peccatte]

PR for this bug: https://github.com/phpmyadmin/phpmyadmin/pull/1158

[Hugues Peccatte]

New PR from QA_4_2: https://github.com/phpmyadmin/phpmyadmin/pull/1159