DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: insert superscript in oracle!!!!

  1. #1
    Join Date
    Jun 2003
    Location
    India
    Posts
    24

    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.

  2. #2
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    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"

  3. #3
    Join Date
    Jun 2003
    Location
    India
    Posts
    24
    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

  4. #4
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    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"

  5. #5
    Join Date
    Jun 2003
    Location
    India
    Posts
    24

    Red face 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
  •  


Click Here to Expand Forum to Full Width