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

Thread: DB Character set

  1. #1
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639

    DB Character set

    Hi Friends,

    Our Applications require the letter "ñ" to be inputed and saved
    in the Database, but when I inserted this char, it was not
    saved. How do I configure my database to accept this one?

    Thanks,

  2. #2
    Join Date
    Jan 2003
    Location
    Hull, UK
    Posts
    220
    Hi,

    did u check it properly,

    I am able to save it in a table and it displays properly.

    Srini

  3. #3
    Join Date
    Dec 2000
    Location
    Mumbai
    Posts
    38
    I am able to insert the same charecter.

    Please check out the Data type used to store the data for that particular column.

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Can you give me some more information on the database version, OS, and the National Language Character set.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  5. #5
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639
    OS AIX 4.3.2
    DB ORA 8.1.5.0
    US ASCII

    Thanks all, :}

  6. #6
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by kris123
    US ASCII
    You can not store such HTML special chars in this characterset.

    PS

    Code:
    WW04_DBA> select * from nls_database_parameters where  PARAMETER = upper('nls_characterset');
    
    PARAMETER                      VALUE
    ------------------------------ ----------------------------------------
    NLS_CHARACTERSET               US7ASCII
    
    WW04_DBA> select chr(241) from dual;
    
    C
    -
    q
    
    WW04_DBA> select chr(177) from dual;
    
    C
    -
    1
    Since this is 7 bit Characterset, max value in binary would be (1111111)=127, when ascii value is 128, it will effectively be 0 so all the literals starting from 128 to 255 will be same as 0 to 127.

    Now just see how 8 bit character set will work.

    Code:
    TEST:ABHAY> select * from nls_database_parameters where  PARAMETER = upper('nls_characterset');
    
    PARAMETER                      VALUE
    ------------------------------ ----------------------------------------
    NLS_CHARACTERSET               WE8MSWIN1252
    
    TEST:ABHAY> select chr(241) from dual;
    
    C
    -
    ¤
    
    TEST:ABHAY> select chr(177) from dual;
    
    C
    -
    ñ
    Hope this helps you.

    Abhay.
    Last edited by abhaysk; 07-18-2003 at 04:47 AM.
    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"

  7. #7
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    You will need to change the character set of the db - documentation here.
    WE8ISO8859P1 is a common choice for European languages.

    ! ! ! Test this since you will have trouble going back if you choose the wrong char set ! ! !

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