MySQL Forums

Hi,
I have encountered the following problem while making my JavaDB Derby application MYSQL compatible.

A statement like this:

UPDATE einstellungen SET wert = 'C:\Users\Andreas\Documents\CPUInfo.txt' WHERE name = 'whatever'

will result in a value "C:UsersAndreasDocumentsCPUInfo.txt" for key 'whatever' :-(

As i support several database systems for use with my application, i would find it pretty odd to have to escape backslashes in a string (varchar) only for MySQL.. do i? When i would generally escape backslashes, it results in double backslashes with other database systems.. :-(

Is there any workaround/setting on teh MySQL database i could change to not remove backslashes?

Than you very much,

Andreas



Edited 2 time(s). Last edit at 11/14/2008 02:23PM by Andraes Weber.