i from 0 to lastidx {
ch = s.charAt(i);
println ch, ' - ', ch.unicode().fmtHex();
}
println;
}
From: "James Huang" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
CC: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: Unicode characters become question marks
Date: Wed, 02 J
Are you characters being escaped before being stored?
\u?
-Original Message-
From: Silvio Lopes de Oliveira
To: Victor Pendleton; James Huang ; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: 6/2/04 6:24 PM
Subject: RE: Unicode characters become question marks
You know, now I'm sure
[EMAIL PROTECTED]
Subject: Re: Unicode characters become question marks
Date: Wed, 02 Jun 2004 13:04:38 -0500
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
James Huang wrote:
> Victor,
>
> I'm positive the database is storing ?'s. You may test with these steps:
>
> 1) ins
Original Message-
From: Jeremy March [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 02, 2004 2:53 PM
To: [EMAIL PROTECTED]
Cc: Silvio Lopes de Oliveira
Subject: RE: Unicode characters become question marks
> You know, now I'm sure that the chars are getting stored as '?&#
> 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
TECTED]
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=, 1,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
James Huang wrote:
> Thanks, Mark. This instills great confidence in me.
>
> I used this URL:
> "jdbc:mysql://localhost/mydb?useUnicode=true&characterEncoding=utf8"
> (should I use "utf-8" perhaps?) Would this work, too?
James,
Either should work, i
PROTECTED]
Subject: Re: Unicode characters become question marks
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
James Huang wrote:
> Victor,
>
> I'm positive the database is storing ?'s. You may test with these steps:
>
> 1) insert "\u7247\u4EEE\u540D" into
? That doesn't look like a standard JDBC method.
-James
From: Mark Matthews <[EMAIL PROTECTED]>
To: James Huang <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: Unicode characters become question marks
Date: Wed, 02 Jun 2004 13:04:38 -050
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
James Huang wrote:
> Victor,
>
> I'm positive the database is storing ?'s. You may test with these steps:
>
> 1) insert "\u7247\u4EEE\u540D" into a UTF8 table;
James,
Have you set your JDBC driver's character set to be UTF-8 using the
characterEncod
ding from the db.
S Lopes
-Original Message-
From: James Huang [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 02, 2004 10:18 AM
To: [EMAIL PROTECTED]; Silvio Lopes de Oliveira;
[EMAIL PROTECTED]
Subject: RE: Unicode characters become question marks
Victor,
I'm positive the dat
[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
PROTECTED]>
To: 'Silvio Lopes de Oliveira ' <[EMAIL PROTECTED]>,Victor Pendleton
<[EMAIL PROTECTED]>,'James Huang '
<[EMAIL PROTECTED]>,"'[EMAIL PROTECTED] '" <[EMAIL PROTECTED]>
Subject: RE: Unicode characters become question marks
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 charact
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 bein
IL 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 charac
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
uot;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 pro
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 Contro
19 matches
Mail list logo
