Hello.
See:
http://dev.mysql.com/doc/mysql/en/Charset.html
Andrew Mull <[EMAIL PROTECTED]> wrote:
> That is what I was wondering, but not sure how to check/set the proper
> character set.
>
> Thanks.
>
> -Andy
>
> Quoting Gleb Paharenko <[EMAIL PROTECTED]>:
>
>> Hello.
>>
"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 Mu
- 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
That is what I was wondering, but not sure how to check/set the proper
character set.
Thanks.
-Andy
Quoting Gleb Paharenko <[EMAIL PROTECTED]>:
> Hello.
>
> You can write a script which will walk through all tables and
> update the rows using replace() function. But, I think, you should
> fin
Hello.
You can write a script which will walk through all tables and
update the rows using replace() function. But, I think, you should
find the source of the problem. What odd characters have appeared after
importing? If they are just unreadable, may be the clue is in wrong character
set.
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
