File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
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: 19973

Start by reading this article.
I agree. Here's the link:
subject: Displaying Chinese data in html
It's not a secret anymore!