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 > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]