OraFAQ Forum: Application Express, ORDS & MOD_PLSQL » Russian charaters are displayed as JUNK

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Russian charaters are displayed as JUNK

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Russian charaters are displayed as JUNK [message #234164]

Mon, 30 April 2007 04:41

pdeepakkumar
Messages: 1
Registered: April 2007
Location: Hyderabad, India.

Junior Member

We are having a UTF8 DB, i am printing russian literals stored in a table using HTP.p, all junk is being displayed. But the same string are shown properly when accessed thru java.

I am using oracle 9i. what could be the issue?

i think it is problem with the oracle, any ideas. please share.

Report message to a moderator

Re: Russian charaters are displayed as JUNK [message #235683 is a reply to message #234164]

Mon, 07 May 2007 12:01

andrew again
Messages: 2577
Registered: March 2000

Senior Member

The characterset in the DAD should be UTF8 too.

select * from v$nls_parameters where parameter in ('NLS_LANGUAGE', 'NLS_TERRITORY', 'NLS_CHARACTERSET');

NLS_LANGUAGE         AMERICAN
NLS_TERRITORY        AMERICA
NLS_CHARACTERSET     AL32UTF8

NLS_LANG is determined by:
NLS_LANG=<NLS_LANGUAGE>_<NLS_TERRITORY>.<NLS_CHARACTERSET>

so DAD is set to NLS_LANG=AMERICAN_AMERICA.AL32UTF8

Report message to a moderator

Previous Topic:	How to install apex in my machine
Next Topic:	How to use owa.cookie

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Aug 31 18:13:17 CDT 2026