Re: Client Character Set

From: Mindaugas Navickas <mnavickas_at_yahoo.com>
Date: 2006-01-05 17:29:38
Message-id: 20060105162938.36365.qmail@web30112.mail.mud.yahoo.com

Hi Raja,
I guess, you issue is sligtly different from what is described in the link. Your database is US7ASCII versus AL32UTF8 talked on the web page. US7ASCII by definition supports ONLY ASCII characters - 32-127.

Permanent solution would be to change character set on database site to support all character that your application is storing.

A temporary solution would be to set a character set on client site to match the database character set (US7ASCII). Search windows registry for the NLS_LANG key:

NLS_LANG=American_America.WE8MSWIN1252 - in your environment might be different and change it to
NLS_LANG={the same as it was}.US7ASCII

Regards
Mindaugas Navickas

• "Subbiah, Nagarajan" wrote:

> Hi List,
>
> I am facing the character set issue. Win2K IIS Client - Oracle 9.2.0.5 on
> HP-UX. Database Character set is US7ASCII. Is there any option to set the
> client character set to resolve the issue and where should I set this up?
>
> Below URL describes the same issue. Looking for the solution.
>
> https://secure.experts-exchange.com/register.jsp?rsid=20&srid=4C0Ba9a2hXvXwW
> 7Ca%2FGQfQ%3D%3D&redirectURL=%2FDatabases%2FOracle%2FQ_21292465.html%3Fqid%3
> D21292465#signup
>
> Thanks
> Raja
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
                                  

---

Find your next car at http://autos.yahoo.ca

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jan 05 2006 - 17:29:38 CST