#721 (2.4.0-dev) Parser and umlauts

[Marc Delisle]

Parser chokes on:

CREATE TABLE gae_config ( mahngebühr1 int(3) NOT NULL
default '0' ) TYPE=MyISAM

I know that the field name should be enclosed with
backticks to be valid for MySQL.

[Alexander M. Turek]

Logged In: YES
user_id=418833

Marc,
even without the backticks, the query should be
valid.

Output of the
parser:

eNodjcFugkAARO/7FXMwURNYF1Yb3aSHLdlYE1gooKanZimIJIIU0ei/eeuPVXudmTdPxXEYC3gO
PBe+0gJ8Cj7DnJEkfRR3QrxNIjBY5QKnn0NrulPR0UOV0XbfcusCh84WcBnjE+ZMXBfMEZwLPkd3
zDLTu1DXFgMS3JIPX2BKGV3YpalrY9fmajc9WScxwsSCXCqdWtioh3ZbNQgjFUu8UDYjUSAFXPqA
7by4kOg9es6sMHkecuo8U2xXWqfEl3opkBf2ud/Zc/Iv9WIlU4VUvvkKpSm+vo/NrioxQm32TVlk
v/d956Bq+hEfQ4cp9Nr3SV7szPnQY8iGGCP9jNRrcFslMvgDkTNUxQ==

[Marc Delisle]

Logged In: YES
user_id=210714

Alexander,

Ok I just read the bit about
"A name may consist of alphanumeric characters from the
current character set and also `_' and `$'. The default
character set is ISO-8859-1 Latin1; this may be changed with
the --default-character-set option to mysqld.

[Robin Johnson]

Logged In: YES
user_id=30201

Duplicate bug
see open bug #593598
(http://sourceforge.net/tracker/index.php?
func=detail&aid=593598&group_id=23067&atid=37740
8)
and also closed bug #593386
(http://sourceforge.net/tracker/index.php?
func=detail&aid=593386&group_id=23067&atid=37740
8)

The long term fix for this really requires reading
what character set the MySQL server is using at
the time (and in the case of MySQL4.1, this would
get a lot harder) and using that character set to
validate the input.

[Alexander M. Turek]

Logged In: YES
user_id=418833

If this is a dublicate, I should close it imho... :-)