It's not a secret anymore!*
The moose likes HTML, CSS and JavaScript and the fly likes Displaying Chinese data in html Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Engineering » HTML, CSS and JavaScript
Bookmark "Displaying Chinese data in html" Watch "Displaying Chinese data in html" New topic

Displaying Chinese data in html

Sara Tracy
Ranch Hand

Joined: Jan 06, 2006
Posts: 45

This question pertains to PLSQL Web Applications.

I'm trying to display some Chinese data on a html page. The data is stored as CLOB in the Oracle database. This piece of code works fine for English data, but for Chinese data it displays upside down question marks. I'm sure it is an encoding issue, but I don't know how to resolve it. Can anybody help me please.

stem clob;
select v.xtext.getClobVal()
into stem
from item_text v
where item_identifier = 31784;

htp.print('<meta http-equiv="Content-Type" content="text/html; charset=utf-8"></meta>');
htp.print('<meta http-equiv="Content-Language" content="zh">');
htp.print('you have reached the chinese page !!');

Also when I run the below statement in iSQLPLus, I'm able to get the correct Chinese data.

select v.xtext
from item_text v
where item_identifier = 31784;

Paul Clapham

Joined: Oct 14, 2005
Posts: 18541

Start by reading this article.
I agree. Here's the link:
subject: Displaying Chinese data in html
Similar Threads
Re: Navigation Restriction
Help!! Chinese(Big 5) Display Problem
JSP returning old data, database was changed correctly!
saving chinese data to text file
the request doesn't contain a multipart/form-data or multipart/mixed stream, content type header is