I've got a problem with MySQL, JSP and foreign-language encoding (UTF-8).

I've got MySQL v4.1 running on XP, JRun4 for the application server and I'm doing fairly simple web work in JSP. I've got sites in multiple languages (16 of them) and am trying to pull UTF8 text (Hebrew, Japanese, etc) out of the database and plop it on the page.

Populating the database works fine - I've input Russian, everything into the database, and when viewing my tables using Navcat (a very nice front-end for MySQL, I must say) I can see the foreign chars showing just fine (they're in varchar and longtext fields). However, when I pipe out the data to Access, or to JRun via the JDBC-ODBC bridge, the output I get is "????????? ???? ?????". All question marks.

Anyone have any ideas?

--tgr

Thaddeus G. Reeves
Internet Dissemination
Church of Scientology Int'l

__________________
Thaddeus G. Reeves
Internet Dissemination
Church of Scientology Int\'l