Hello.
See:
http://dev.mysql.com/doc/mysql/en/Charset.html
Andrew Mull <mull@stripped> wrote:
> 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
