#112 mdb-export -I escapes not correct

open
nobody
5
2007-03-26
2007-03-26
John Nagle
No

"mdb-export -I" creates SQL INSERT statements with the field values quoted, which is correct. It appears to escape quotes, which is correct. But it doesn't escape backslashes as well, which is incorrect. This does bad things to Windows pathnames in .mdb files, and can generate SQL like

INSERT ... "c:\foo\"

which is not valid SQL.

The escape options for mdb-export allow setting some options for escaping, but they aren't powerful enough to express the format needed for SQL.

Discussion