Yes. The source data were "\uXXXX" escaped in Java, and the data read out of
mysql were HTML-escaped into #&12345; and set to browser; the browser does
display Chinese characters correctly.
From: Victor Pendleton <[EMAIL PROTECTED]>
To: 'James Huang ' <[EMAIL PROTECTED]>,"'[EMAIL PROTECTED] '"
<[EMAIL PROTECTED]>,"'[EMAIL PROTECTED] '" <[EMAIL PROTECTED]>
Subject: RE: Unicode characters become question marks
Date: Wed, 2 Jun 2004 11:51:22 -0500
Can you display properly handle the Chinese characters? I would try to
verify that the correct unicode code is being stored.
-----Original Message-----
From: James Huang
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: 6/2/04 11:45 AM
Subject: RE: Unicode characters become question marks
I saw the same problem with 5.0 alpha and Java/JDBC. The text was
Chinese
characters in Java; the tables were created with default character set
UTF8.
Seems only questions marks are stored.
Wondering if far-east characters in UTF8 are support by MySQL's UTF8
support?
-James
>From: "Silvio Lopes de Oliveira" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Subject: Unicode characters become question marks
>Date: Wed, 2 Jun 2004 09:39:14 -0700
>
>MySQL Server: 4.1.1 alpha
>MySQL Control Center: 0.9.4 beta
>
>I am not sure whether this is a Control Center or MySQL Server problem,
but
>here it goes:
>
>I have a database with MyISAM tables created using character set UTF-8.
I
>have installed support for Chinese on my machine, and using MySQL
Control
>Center I entered some values in Chinese for some varchar fields. I had
also
>changed the app font for Control Center to SimSun, which supports
Chinese
>characters. When I requery the table, the Chinese characters have been
>changed to question marks. I expected, of course, that the Chinese
>characters would be displayed.
>
>I tried this to access the data programatically (using an MFC app and
ODBC
>Connector) and it also shows question marks. I'm not sure whether the
>conversion to question marks occurs when the data is stored into the
table,
>or when the data is retrieved.
>
>I found the following discussion thread debating what seems to be a
similar
>issue, but it was not clear whether to me they ever determined a
solution
>or if it is a bug:
>
> http://lists.mysql.com/mysql/164067
>
>Here are the values for my character set variables:
>
>+--------------------------+--------------------------+
>| Variable_name | Value |
>+--------------------------+--------------------------+
>| character_set_server | utf8 |
>| character_set_system | utf8 |
>| character_set_database | utf8 |
>| character_set_client | utf8 |
>| character_set_connection | utf8 |
>| character-sets-dir | C:\mysql\share\charsets/ |
>| character_set_results | utf8 |
>+--------------------------+--------------------------+
>
>I am starting the MySQL server as follows:
>
> mysqld --default-character-set=utf8
>
>I need to see the Chinese characters both in Control Center and my MFC
app
>which uses ODBC Connector.
>
>Thanks,
>S Lopes
>
>
>--
>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]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
