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 <[EMAIL PROTECTED]> 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 / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ 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/[EMAIL PROTECTED]