-
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.
-
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
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
Luv
Kanna
-
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
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
oracle superscript insertion
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|