MySQL Forums
Forum List  »  Newbie

Can not get proper utf8 text
Posted by: Robert Lee
Date: June 07, 2011 10:21AM

I'm trying to get some utf8 text fields (could be Chinese, Japanese, Korean or others) from a remote MySQL database which I have no control over.

The database's character encoding settings:
character_set_client: utf8
character_set_connection: utf8
character_set_database: latin1
character_set_filesystem: binary
character_set_results: utf8
character_set_server: latin1
character_set_system: utf8

In my connection string, I set explicitly "characterset=utf8". And before querying for any data, I send the command "SET NAMES UTF8". I searched the web and that seems all I have to do to make utf8 fields work.

However, I just could not get those utf8 fields properly displayed.

I used both MySQL Workbench (the latest version) and a small C# program I wrote myself (for trying different encoding conversion). Both show the same result.

What else should I do? Please help. Thanks.

Bob



Edited 2 time(s). Last edit at 06/07/2011 10:32AM by Robert Lee.

Options: ReplyQuote


Subject
Written By
Posted
Can not get proper utf8 text
June 07, 2011 10:21AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.