Re: store $FF on Oracle9 with VARCHAR2 type

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Fri, 22 Jul 2005 21:41:14 +0200
Message-ID: <dbri4k$r86$01$1@news.t-online.com>

pcouas_at_infodev.fr wrote:
> Just an Idea,
>
> There is no NLS_CHARSET in my Linux variable environnement for my Linux user ?
> Do you think this is an problems ??
>
> Regards
> Philippe

For your linux environment locale are following variables responsible:

LC_CTYPE
LC_COLLATE
LC_MONETARY
LC_NUMERIC
LC_TIME
LC_MESSAGES
LC_ALL

LANG Oracle evaluates NLS_LANG variable, but has no clue about NLS_CHARSET. NLS_CHARSET variable can be set, but it will be not evaluated nor from linux, neither from oracle.
In Oracle terms NLS_CHARSET is used for characterset of your database, which you can define by creation of database and later ( under some circumstances ) change only by "ALTER DATABASE CHARACTER SET new_character_set" (
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96529/ch10.htm#1009904 http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14225/ch11charsetmig.htm#sthref1343) and you can not control it by setting of environment variables.

Best regards

Maxim Received on Fri Jul 22 2005 - 14:41:14 CDT