aspose file tools
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 OCA Java SE 8 Programmer I Study Guide 1Z0-808 this week in the OCAJP 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: 19119

Start by reading this article.
It is sorta covered in the JavaRanch Style Guide.
subject: Displaying Chinese data in html