On other instances, " are escaped as \"...I would think that should translate
correctly?
Thanks
Quoting Andrew Mull <[EMAIL PROTECTED]>:
> 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 [EMAIL PROTECTED]:
>
> > 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 <[EMAIL PROTECTED]>
> > > To: mysql@lists.mysql.com
> > > 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/[EMAIL PROTECTED]
> >
> > ---------- End Original Message ----------
> >
> >
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
