Re: changing decimal character on windows

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Wed, 06 Nov 2002 18:40:31 +0100
Message-ID: <qukisu4kmni16dqd1i2fu5bsqcbucgk3q3@4ax.com>

On Wed, 6 Nov 2002 16:31:17 +0100, "Bengali" <ldewavrin_at_nerim.net> wrote:

>Hi,
>i am running Oracle Database 9.2.0 on Windows 2000 ( French Language).
>I'd like to permanatly change the decimal character of my oracle instance
>from ',' to '.' .
>
>As suggested in documentation, i added to
>%ORACLE_BASE%/admin/%ORACLE_SID%/pfile/init.ora.972002192319
>the following initialization parameter : NLS_NUMERIC_CHARACTERS = ",. "
>
>But it doesn't seem to take affect after the database restart.
>
>I don't understand why?
>When i type in sqlplus 'show parameter NLS_LANGUAGE' i get:
>nls_language string AMERICAN
>
>'show parameter NLS_TERRITORY'
>nls_territory string AMERICA
>
>'show parameter NLS_NUMERIC_CHARACTERS'
>nls_numeric_characters string
>
>Am i proceeding the right way?
>-I also changed Windows locale from french to English ( United States) but i
>get
>the same decimal character ( i.e ,).
>- I created the database with the "database configuration assistant".
>
>
>Thanks in advance,
>Luc
>
>
>

setting this in init.ora will only affect code run on the server. You need to set this in the registry in hklm\software\oracle

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Nov 06 2002 - 11:40:31 CST