[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-java
Subject:    RE: Unicode insertion in 4.1
From:       "Paul Wallace" <pwallace () twowaytv ! com ! au>
Date:       2005-09-13 4:38:29
Message-ID: 766DD168B8AFFB41B7FB1689163F15EA029421 () marge ! pyrmont ! twowaytv ! com ! au
[Download RAW message or body]

Hi, 
	Yeah, I wrote a small Swing app - data in -> data out, and
tested it on a new install of 4.1. While the characters in Query Browser
resembled pipes rather than question marks (||||||||||||||||), when
extracting the data and displaying it, the Thai characters were returned
and rendered successfully. The server was set as default UTF8 on install
time. How can I set an existing install default character set without
having to reinstall?
	Also, why is it necessary to specify say CHARACTER SET tis620
COLLATE tis620_thai_ci and not simply UTF8? Does that mean I have to
specify precise character sets per application on DB build time? That I
thought defeats the purpose of Unicode?

Thanks for your tolerance if I am woefully misguided.

Paul.

Paul Wallace schrieb:
> and am inserting using a PreparedStatement - 
> pstmt.setString(indexOfColumnInQuestion, asianTextString); to insert 
> in to message_body. However, when viewing the column in Query Browser,

> and retrieving it from a ResultSet, it reads ????????????? ??? ???? 
> and so on (I am attempting to insert Thai characters in this
instance).

Is the number of '?' correct, i.e. is this the number of asian
characters? If so, the displaying program (Query Browser) may have the
wrong font (a font without the asian characters in it) or has set the
wrong encoding (not UTF8) of the Strings, Panels, Labels etc.
Try to write a small Java program which is retrieving the data from the
database and printing it to a File while the OutputStream's encoding is
set to UTF8. And then open the file with an editor or browser capable of
displaying UTF8.

Ronald


--
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe:
http://lists.mysql.com/java?unsub=pwallace@twowaytv.com.au


-- 
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe:    http://lists.mysql.com/java?unsub=mysql-java@progressive-comp.com


[prev in list] [next in list] [prev in thread] [next in thread]