Re:Accented characters in TEXT field getting mangled

Hello Jonathan, 

I had the same problem with the Tomcat/Mysql  and Linux, but I solved this 
problem when I put this command 

("charset","ISO8859-1")  in my Java/Tomcat aplication. 

Regards, 

Edival 


I am developing a web application using Java/Tomcat and MySQL 4.1.12 
with Connector/J 3.13.13. 

When I save something with an accent like "Café" to a VARCHAR column, it 
works fine on both my development Windows XP laptop, and our production 
Linux server. 

When I save something with an accent into a TEXT column, it works fine 
on the Windows box, but the Linux systems return "Café". 

The code I am using to set the TEXT column value is: 

byte[] bytes = text.getBytes(); 
InputStream textInputStream = new ByteArrayInputStream(bytes); 
preparedStatement.setAsciiStream(1, textInputStream, bytes.length); 

Obviously I am doing something wrong since the unicode is getting messed 
up on the production db, although I'm confused as to why it's working ok 
on my dev windows box. 

Do I need to be doing something different?  setCharacterStream? 
setUnicodeStream?  setClob() ? 

Thanks! 
Jonathan


-- 
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe:    http://lists.mysql.com/[email protected]