[chavez1000]

I have a delphi app with odbc/bde connection to the oracle 9i DB. The servers operating system it´s windows2000 Terminal Server. Sometimes I have seen that the thousans separators in the database show like this "10,000" and sometimes like this "10.000"
Any suggestion.

Thanks

[LKBrwn_DBA]

Check the NLS_LANG parameter in those clients where the separator is incorrect.

Also make sure the NLS_NUMERIC_CHARACTERS parameter is not being modified by the session.

[chavez1000]

Originally posted by LKBrwn_DBA
Check the NLS_LANG parameter in those clients where the separator is incorrect.

Also make sure the NLS_NUMERIC_CHARACTERS parameter is not being modified by the session.

I don´t know how to make this. Can you show me how? or where I can find information about that.

Thanks a lot

[LKBrwn_DBA]

In your windows client look under:

HKEY_LOCAL_MACHINE>SOFTWARE>ORACLE

Key name: NLS_LANG
String: (Look in: http://download-west.oracle.com/docs...a90236/toc.htm)


Other parameters that may be changed by the user session are the monetary paramaters that drive the currency and punctuation symbols: NLS_CURRENCY, NLS_ISO_CURRENCY, NLS_MONETARY_CHARACTERS which are driven by the 'TERRITORY' setting ing NLS_LANG or by default in NLS_TERRITORY.

You may want to check these settings in the database to compare against the setting of NLS_LANG in the clients.

Good luck.