I already have my table structure in place in MySQL, and I just want to import the data from my Access 2000 database. (the .mdb is about 50 megs)
The MySQL server is on a Linux system. I've been using DBTools to do the import, because it allows me to import just the data, and not create the tables. (I don't want it to create the tables, because it's creates them inccorectly. I used another tool to create the schema, and and fixed all the problems with it.) My problem is that when the import is done, all my varchar (text in access) and text (memo in access) field data leaves behind escape switches. All quotes look like this \' or \" and all linefeeds look like this \r\n. I also have other weird characters in the data. If I export the data using MySQL-Front, I get stuff like this: \\\" \\\' \\r\\n Also, some of my data has special characters like the ellipses characer, ., and when I view access the data through my code, it comes out like this ?. What is the best way to import data to a MySQL server on Linux and preserve the correct escaping? Ian. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
