> Yeah. I am moving data from mysql server to sql > server. > Because I have single quote in some strings, it > generated errors when I ran mysqldump scripts in sql > server to import data in. > i.e. strings Here's, Martin's ,... caused trouble. > Does that mean sql didn't recognize escaped single > quote? > Thanks, > Monet > I *think* sql server escapes single quotes *only* when two appear together. So two single quotes in a row equals one single quote. Brilliant, eh? ...To be a fly on the wall when that decision was made. :-) I think that is actually the ANSI SQL standard for escaping single quotes and not just an M$ thing. It works in MySQL too by the way. Try it:
INSERT INTO testing values('Here''s','Martin''s','mom''s'); same as INSERT INTO testing values('Here\'s','Martin\'s','mom\'s'); I suppose you could try to open the dump file in an editor like vi or notepad or some other editor that has a search and replace and replace \' with '' and see what happens. vi: :%s/\\'/''/g The alternative would be to use mysqdump with -T option and use the options --fields-terminated-by=, --fields-enclosed-by=, --fields-optionally- enclosed-by=, --fields-escaped-by=, and --lines-terminated-by= to make a csv file. You can use BCP or MS DTS to load a csv into sql server tables. There may be another sql server equivelant to LOAD DATA INFILE that can accept csv or tsv. Who knows??? Good luck, Jim Grill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]