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]
