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
