Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Russian charaters are displayed as JUNK
Russian charaters are displayed as JUNK [message #234164] Mon, 30 April 2007 04:41 Go to next message
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.

Re: Russian charaters are displayed as JUNK [message #235683 is a reply to message #234164] Mon, 07 May 2007 12:01 Go to previous message
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

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


Current Time: Thu Mar 28 07:14:00 CDT 2024