Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: NLS character settings

Re: NLS character settings

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 3 Mar 2004 18:34:16 +0100
Message-ID: <40461677$0$24961$626a14ce@news.free.fr>

"Robert Gallas" <gallasr_at_ustr.slposta.sk> a écrit dans le message de news:c24oqu$pil$1_at_news.telecom.sk...
> Hello,
>
> I have question about NLS character settings.
>
> We have database created in:
>
> NLS_CHARACTERSET WE8DEC
> NLS_NCHAR_CHARACTERSET WE8DEC
>
> 1st. scenario
> client NLS_LANG = AMERICAN_AMERICA.WE8DEC
> - in one session inserted character of byte value 9E
> - in the same session select returned character 9E
> Result is correct
>
> 2sn. scenario
> client NLS_LANG = AMERICAN_AMERICA.EE8MSWIN1250
> - in one session inserted character of byte value 9E
> - in the same session select returned character ?
> Result is incorrect
>
> I have never been confronted with NLS setting in oracle enviroment so I do
> not really understand what is going on in background when converting
> characters. I have thougth that when converting from client session NLS to
> server NLS to store character is the same conversion as reading character
> from server NLS converting to client session NLS just vice versa. So what I
> do not understand shy oracle changes byte value of the character. Can
> samobody explain me this? Oracle is able to store 9E byte but just when the
> session NLS and server NLS are same_ I have a little(much) confusion in this
> NLS stuff.
>
> What I thought was that oracle session takes 9E in EE... converst it to XX
> in WE...(acording to combination of client NLS and server NLS) when storing
> and vice versa when reading data if and only if the NLS combination of
> client and server is the same.
>
> Thanks in advance
> Robert
>
>

Show us the exact statements you use for insert and select. How do you know you really inserted character with byte value 9E?

Regards
Michel Cadot Received on Wed Mar 03 2004 - 11:34:16 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US