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
--- [EMAIL PROTECTED] wrote: > Jim - He needs to change the format because he isn't > exporting from one > MySQL database to another.... His destination > database doesn't like the > escaped single quotes. > > Here is the manual page for mysqldump: > http://dev.mysql.com/doc/mysql/en/mysqldump.html > > Is there nothing you can do with > --fields-terminated-by=... > --fields-enclosed-by=... > --fields-optionally-enclosed-by=... > --fields-escaped-by=... > --lines-terminated-by=... > > to get what you want from mysqldump? > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine > > "Jim Grill" <[EMAIL PROTECTED]> wrote on > 09/24/2004 02:35:40 PM: > > > > Hello everyone, > > > > > > In mysqldump output txt file, all datetime, > varchar, > > > text fields value are surrounding by single > quotes. Is > > > there any way that the single quotes can be > replaced > > > by double quotes in the txt file? > > > Furthermore, if you have a single quote in text > field, > > > it will automatically replaced by \'. But I like > to > > > keep it in the way it input. > > > > > > > There is no way to change the use of single quotes > in a standard dump. > The > > only time you have a choice is when you use the -T > option, which creates > a > > tab or csv type dump files depending on options > present on the command > line. > > You could use this option if you wanted. The only > draw back is that > > mysqdump -T must be run on the same machine as the > server. > > > > However, why is the presents of escaped single > quotes a problem? They > are > > only escaped to let MySQL know to treat them as > literal single quotes > and > > not string delimiters. They do not actually get > inserted into your table > > with the slashes. > > > > Regards, > > > > Jim Grill > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > _______________________________ Do you Yahoo!? Declare Yourself - Register online to vote today! http://vote.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
