Description:
The 28'th Danish letter in uppercase (the letter "Ø") when used in a character string seems to disturb the parsing of the following lines: For every count of "Ø" in the string the parser skips over the same number of non-white space characters from the beginning of the command!
The application was installed with the default settings.
The same scripts runs OK directly on the MySQL server.
The severity is critical for Danish users (this letter is often used!).
How to repeat:
Here is a sample of inserts:
INSERT INTO address
VALUES ( 1, NULL, "Aaaaaaaaaa 1", NULL, "1111", "Ølgod",
"1111-1111", "1111-1111" );
INSERT INTO factories VALUES ( 1, "10", "Xxxxxx" );
INSERT INTO factories VALUES ( 2, "20", "Xxxxxx" );
COMMIT;
The "Ø" in "Ølgod" will disturb the parser to interprete the next lines as:
NSERT INTO factories VALUES ( 1, "10", "Xxxxxx" );
NSERT INTO factories VALUES ( 2, "20", "Xxxxxx" );
OMMIT;
If more than one "Ø" is present, for example "ØlgodØ" (2 of them) then the parser will interprete the lines as follow:
SERT INTO factories VALUES ( 1, "10", "Xxxxxx" );
SERT INTO factories VALUES ( 2, "20", "Xxxxxx" );
MMIT;
(2 dropped characters)
Suggested fix:
Workaround:
Scripts may be run directly from the MySQL command interpreter, as it does not seem to have problems.
