insert superscript in oracle!!!!

Hi all,
let's see the following example.

create table TEST_M_EMPLYMT_TYPE
(counrtry_code varchar2(2),
code1 number,
val1 varchar2(2),
code2 number,
cur_user varchar2(10),
val2 date,
val3 varchar2(10),
code3 number)

SQL> /

Table created.

SQL> insert into TEST_M_EMPLYMT_TYPE values('UK', 99, '¹', 1,user,sysdate,'',0);

1 row created.

SQL> select * from TEST_M_EMPLYMT_TYPE;

CO CODE1 VA CODE2 CUR_USER VAL2 VAL3 CODE3
-- ---------- -- ---------- ---------- --------- ---------- ----------
UK 99 ¹ 1 CCRTADMIN 11-JUL-03 0

the values are correctly inserting in oracle 9i, and oracle 8.1.6, but i couldn't insert in 8.1.7, if i insert then for superscript 1 it's inserting as "?".

i searched in sites for that they told to change the NLS_CHARACTERSET.

i tried in local machine, i couldn't change in init.ora file.

is there any way to change the NLS_CHARACTERSET without recreating the database?

please clarify this..


thanks in advance.....


kanna.

http://download-west.oracle.com/docs...10.htm#1009580

Thnx
But I need something like NLS_DATE_FORMAT...
since we can change them for a given session.
Is there a similar approach?
Thnx in advance

Quote:

---

Originally posted by kanna
Thnx
But I need something like NLS_DATE_FORMAT...
since we can change them for a given session.
Is there a similar approach?
Thnx in advance

---

Search in the web u will get one

Hihihihihi, i think you didn't read my first mail properly.
in that itself i mentioned that i gone thro all sites.....i couldn't find a solution for this.

That's the reason i posted here....

anyway thanks...


kanna