Inserting uft8 strings into MySQL from jsp page

[krismac]

Hi...

Ok I have created a form which posts data into a mysql database. I can then read that data from the database with another page.

I am trying to add russian text to the database... it says it has been added but it comes back as ?????

I can use PHPAdmin to add russian text and it is displayed properly on my JSP page.

So im guessing i am missing something in my insert statement...

sql = dbconn.prepareStatement("INSERT INTO property VALUES ('" + ref + "');");

text that doesnt come from the database also displays correctly.

its mysql 4.1+

any help would be great!

thanks.