Inserting uft8 strings into MySQL from jsp page

•

What is DaniWeb IT Discussion Community?

You're currently browsing the JSP section within the Web Development category of DaniWeb, a massive community of 427,800 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,772 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our JSP advertiser: Lunarpages JSP Web Hosting

Thread Tools Display Modes

Views: 2154 | Replies: 0

•

Join Date: Nov 2006

Posts: 1

Reputation: krismac is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

krismac

Offline

Newbie Poster

Inserting uft8 strings into MySQL from jsp page

Nov 28th, 2006

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.