That is what I was wondering, but not sure how to check/set the proper
character set.
Thanks.
-Andy
Quoting Gleb Paharenko <gleb.paharenko@stripped>:
> 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.
>
>
>
> Andrew Mull <mull@stripped> wrote:
> > 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
> >
>
>
> --
> For technical support contracts, goto https://order.mysql.com/?ref=ensita
> This email is sponsored by Ensita.NET http://www.ensita.net/
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Gleb Paharenko
> / /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
> /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
> <___/ www.mysql.com
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
>
