On other instances, " are escaped as \"...I would think that should translate
correctly?
Thanks
Quoting Andrew Mull <mull@stripped>:
> When I look at the dump file, I see that one of the invalid characters is
> represented as /226 I'll have to look to see if it is consistent, and just
> replace it.
>
> Thanks.
>
>
> Quoting mysql-list-replies@stripped:
>
> > are you sure that the single/double quotes in your original data were
> > actually the standard ascii characters (decimal 39 (') and 34 (")) --
> > not "smart quotes"? you shouldn't have any trouble with the standard
> > quote characters, but as the representation of "smart quotes" isn't
> > standard you will.
> >
> >
> > ---------- Original Message ----------
> > > From: Andrew Mull <mull@stripped>
> > > To: mysql@stripped
> > > Date: Tuesday, January 04, 2005 10:19:20 AM -0500
> > > Subject: Embedded Quotes and Special Characters.
> > >
> > > I'm moving a database from one server to another. Both are unix
> > > based, however the original database is on a Solaris box, and the
> > > new server is RedHat.
> > >
> > > The database has embedded "s and 's in some of the varchar fields.
> > > When I moved the database, I did a mysqldump, copied the text file
> > > to the new server, and imported the data. The database on the new
> > > server is now showing odd characters in place of the original "s and
> > > 's.
> > >
> > > Is there a way to fix this problem?
> > >
> > > Thanks!
> > > -Andy
> > >
> > > --
> > > MySQL General Mailing List
> > > For list archives: http://lists.mysql.com/mysql
> > > To unsubscribe:
> > > http://lists.mysql.com/mysql?unsub=1
> >
> > ---------- End Original Message ----------
> >
> >
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
>
