2 messages in com.mysql.lists.bugsBug: Cannot import file
FromSent OnAttachments
Tobias Wiersch23 Mar 2001 14:23.xxx
Michael Widenius24 Mar 2001 05:04 
Subject:Bug: Cannot import file
From:Michael Widenius (mon@mysql.com)
Date:03/24/2001 05:04:44 AM
List:com.mysql.lists.bugs

Hi!

"Tobias" == Tobias Wiersch <swi@home.ins.de> writes:

Tobias> Hi! Tobias> To make it short: MySQL seems to have problems with char 0x1a, when Tobias> parsing dumps.

Tobias> I attached a very, very short example so you can see it by yourself. Tobias> MySQL always says: You have an error near ''' at line 1.

Tobias> Is there a fix? Tobias> Thanks in advance!

Tobias> ... tobias wiersch from germany

Tobias> PS: 3.23.33

Tobias> INSERT INTO test (CryptedPassword) VALUES (' ');

The above works perfectly when you are running unix. On windows you the above will give you a problem as windows thinks that ^Z means end of file. For example, when using redirect, or windows streams, MySQL will never see the ^Z character.

Fix:

Replace ^Z with \Z

Regards, Monty