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. >> >> 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]
