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