[ mdbtools-Bugs-1688770 ] mdb-export -I escapes not correct

Bugs item #1688770, was opened at 2007-03-26 21:25
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=102294&aid=1688770&group_id=2294

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: cmd line utils
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: John Nagle (nagle)
Assigned to: Nobody/Anonymous (nobody)
Summary: mdb-export -I escapes not correct

Initial Comment:
"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.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=102294&aid=1688770&group_id=2294

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV