You know, now I'm sure that the chars are getting stored as '?' as well. I tried the
test you suggested again, but with a small modification. I typed:
SELECT IF(networkname='?', 1, 0) from networktable;
and it returned 1. Because I used '?' instead of the chinese char and it matched, then
obviously the stored character is a '?'. So my conclusion is the same as James
Huang's; the problem happens when the string is stored. But no solution yet, though.
S Lopes
-----Original Message-----
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 02, 2004 10:09 AM
To: Silvio Lopes de Oliveira; Victor Pendleton; 'James Huang ';
'[EMAIL PROTECTED] '
Subject: RE: Unicode characters become question marks
If you can type the character into the keyboard try this.
SELECT IF(col1=<chinese-character>, 1, 0)
Else try this from a java program
if (rset.getString(col1).equals(<chinese-character>))
{
System.out.println("match");
}
else
{System.out.println("invalid");
}
-----Original Message-----
From: Silvio Lopes de Oliveira
To: Victor Pendleton; James Huang ; [EMAIL PROTECTED]
Sent: 6/2/04 11:59 AM
Subject: RE: Unicode characters become question marks
Yes, my display can handle the Chinese characters. I have also changed
the application font of MySQL Control Center to SimSun, which supports
all the Chinese characters I am using. When I type the characters in
MySQL Control Center, I see the Chinese characters. I edit a varchar
field in an existing record, I type the Chinese content, hit enter, save
the table, and I still see the Chinese characters. When I requery the
table, the Chinese characters have become question marks.
As for verifying whether the correct Unicode is being stored, how do I
do that? All I can see once I requery are the question marks. I don't
know whether the Unicode is being stored as question marks, or whether
it is stored correctly and is getting converted to question marks when
the stored data is retrieved.
S Lopes
-----Original Message-----
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 02, 2004 9:51 AM
To: 'James Huang '; Silvio Lopes de Oliveira; '[EMAIL PROTECTED] '
Subject: RE: Unicode characters become question marks
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]
