Character Setting Problem ( mysql + tomcat )

Hi all;

I am using mysql dbms and tomcat web server(servlet). But in my web page, the characters are shown broken. I set the character set of the mysql database. They are shown well in the dbms console. And also I set the html code with appropriate character set in the meta tags. Do I need to make any extra setting? Perhaps in the tomcat or anywhere else? What is the problem here?

[396 byte] By [softengilkera] at [2007-11-26 15:43:04]
# 1

assumes:

1. using jsp to display the db data

2. db encoding is ISO-8859-1

3. jsp encoding is utf-8

for the very first line of the jsp file:

<%@ page pageEncoding="utf-8" %>

before displaying the data:

String str = <data from db>

str = new String(str.getBytes("ISO-8859-1"), "UTF-8");

sleeper108a at 2007-7-8 22:01:58 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...
# 2
Unfortunately, it doesn't work. Db encoding is latin5(iso-8859-9) and page encoding utf-8.
softengilkera at 2007-7-8 22:01:58 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...