a software.
Cheers!
-James Huang
//
// File: connect.judi
//
connect to
'jdbc:mysql://localhost/mydb?useUnicode=true&characterEncoding=utf-8',
'myuser', 'myuser';
//
// File: mysqltest.judo
//
!include 'connect.judi'
asUnicode = &#x
This test code works, with both mysql-connector-j 3.0.14 and 3.0.11, against
mysql 5.0-alpha. I'll look more and report anything if interesting.
Thanks,
-James
From: Mark Matthews <[EMAIL PROTECTED]>
To: James Huang <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED], [EMAIL PROTECTED],
? 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
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
Yes. The source data were "\u" 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 ' <[EMA
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
:';
while $q.next() {
println $q[1] :>5, ' ', $q[2]; // first column right adjusted
// println $q.id :>5, ' ', $q.name; // another way.
}
Cheers!
James Huang, author of JudoScript
_
