Daniel Kasak wrote: >The data has a field which has some quotes in it. The field looks like >this ( all quotes included ): >'' '' > >ie 2x single quotes, a space, and 2x single quotes. >Don't ask me why. I didn't put it there. Anyway, mysqldump has packaged >this field as follows: >'\'\' \'\'' > >
Update. Perhaps this is 2 bugs in 1. I've found a LOT of this sort of thing in the dump file. It seems that every single quote that's encountered is represented: \'\' ... instead of just: \' But still, mysql should simply import 2 quotes where there should have been one, right? I don't know. I'm starting to get confused. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]