Thanks Jim. Great suggestions.
I will try both to see which one is better for my
case.
Appreciated your help.
Monet
--- Jim Grill <[EMAIL PROTECTED]> wrote:
> > 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]
>
>
__________________________________
Do you Yahoo!?
Yahoo! Mail - You care about security. So do we.
http://promotions.yahoo.com/new_mail
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
