Re: Chinese Charset is displayed as '????'
You got to keep a few points in mind.
1. The respective columns in MySQL should be defined to hold UTF-8 or whatever character set you're using with a suitable collation. I'm using MySQL to store Thai language in a certain table - so my charset for this table/column is "tis620" and collation is "tis620_thai_ci"
2. The VB.NET Connection string should contain the the word "CHARSET=utf8" in order to enable VB to send in the characters with proper encoding to MySQL. An example statement in VB would be:
===============================================
ConnectionString = "SERVER=10.19.168.100;PORT=3306;DATABASE=somedb;User Id=someuser; PASSWORD=somepass;CHARSET=utf8"
Notice the usage of the CHARSET=uf8 --> THIS IS A MUST !!
These two steps were enough to let me store Thai in MySQL - and I believe its not different for Chinese at all.
3. If you're trying to view your database using the MySQL Command Line Client - then, your DB will ALWAYS SHOW UP WITH "??????????????" FIELDS. There's no way to avoid this - as the command line console is incapable of displaying UTF-8 characters yet. One of you replied that you can view it perfectly through phpMyAdmin - and that's how you SHOULD view the data. It's impossible to display it correctly unless it's viewed through a GUI supporting UTF Charsets.
Another alternative for you guys is to download and install the MySQL Query Browser from this site - that'll help you view your DB in proper format. One word of advice - use the command line tool for database creation/manipulation tasks - and for TESTING how different combinations of your queries react. I find it a lot faster this way. But viewing DB Contents should always be done through a GUI.
All the best with your venture. Believe me - it's NOT at all as frustrating it might seem.. follow step 1 & 2 and you'd have it in no time. Even I was amazed at the simplicity of the whole task once I got it done. :)
...the average population of all the planets in the Universe can be said to be zero. From this it follows that the population of the whole Universe is also zero, and that any people you may meet from time to time are merely products of a deranged imagination.
Subject
Views
Written By
Posted
11377
March 02, 2005 04:41AM
7790
March 02, 2005 08:02AM
6004
March 02, 2005 07:54PM
6044
March 03, 2005 02:23AM
8628
March 05, 2005 03:54AM
5454
March 16, 2005 03:56AM
4717
April 05, 2005 03:13AM
Re: Chinese Charset is displayed as '????'
6249
April 06, 2005 09:10AM
4095
October 24, 2005 10:47PM
3891
November 03, 2005 01:55AM
3733
April 21, 2005 07:45AM
7398
June 28, 2005 10:44PM
3780
November 03, 2005 03:01AM
3472
December 01, 2005 09:34PM
3569
December 08, 2005 03:06AM
3263
July 13, 2005 03:18AM
3522
August 15, 2005 01:58PM
19258
January 18, 2007 09:47PM
5249
October 24, 2005 11:41PM
3643
October 25, 2005 02:07AM
3347
November 04, 2005 09:40AM
3323
March 22, 2006 04:03AM
3406
April 05, 2006 10:01AM
4337
May 25, 2006 01:33PM
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.