Inserting pound sign into a table...

[anandkl]

Hi Friends,
We have DB which is having NLS_LANG=GERMAN and
NLS_CHARACTERSET US7ASCII. We have an issue with inserting the pound sign i.e UK currency.The Database is 7 Bit -character set.Can u please help me in how i insert the pound sign into a table.

regards
anandkl

[DaPi]

I'm pretty sure you need an 8-bit character set to do that.

[anandkl]

Hi Dapi,
Thanks for the reply,
how can i convert my 7 bit to 8 bit character set.Can u please guide
and what are its effect on Database.

regards
anandkl

[davey23uk]

you cant change character set, will need a new database and imp/exp or something like that

[DaPi]

Oh yes you can, providing the old set is a sub-set of the new one. Look in the NLS manual chapter 3:

ALTER DATABASE [ db_name ] CHARACTER SET new_character_set;
ALTER DATABASE [ db_name ] NATIONAL CHARACTER SET new_NCHAR_character_set;

(We are pretty international here and use WE8ISO8859P1 - there are other options . . . )

[anandkl]

Ok...thanks DaPi..

I will try this.

regards
anandkl

[anandkl]

Hi Friends
I was able to display and store the pound sign...

I set my client side NLS_LANG=NLS_LANG=American_America.US7ASCII
and once loged into sqlplus i execucted

select chr(163) from dual;

I got the Pound sign and was able to store the same into a table..

Thanks every body for the feedback and suggestion.

regards
anandkl