Re: Currency Symbols

If you are using Unix, you should set up NLS_TERRITORY and NLS_ISO_CURRENCY as environment variables. If using NT, set these values up in the registry.

The database would also have needed to be created using an 8 bit character (i.e WE8ISO8859P1) set and not just the default (US7ASCII) character set. You can check which character set was set when the DB was created by looking in the table sys.props$. If you need to change the character set, you really need to re-create the database.

HTH NeilC

John wrote in message <3834ff2a_3_at_news2.vip.uk.com>...
>thanks for that , sorry I don't really understand what you mean by env var
>or registry key. Are you saying i need to chnage a registry setting on the
>server?
>Sybrand Bakker <postmaster_at_sybrandb.demon.nl> wrote in message
>news:942963305.27130.0.pluto.d4ee154e_at_news.demon.nl...
>> This can be accomplished by either setting NLS_TERRITORY or
>NLS_ISO_CURRECNY
>> and if you want them to be permanent they need to env var or registry
key.
>> If they should be non-permanent use alter session.
>> There is a view v$nls_valid_values where you can see which values can be
>> used.
>>
>> Hth,
>>
>> --
>> Sybrand Bakker, Oracle DBA
>> John <jbraddon_at_bluecarrots.com> wrote in message
>> news:3834641d_1_at_news1.vip.uk.com...
>> > My database reports currency in $ but i need it in £, I've tried
messing
>> > around with nls parameters in the init.ora but to no avail as i don't
>> really
>> > know what i should be doing. Any help would greatly appreciated.
>> >
>> > John
>> >
>> >
>> >
>> >
>> >
>> >
>>
>>
>
>
Received on Fri Nov 19 1999 - 03:01:31 CST