8 Replies Latest reply: May 9, 2012 6:56 AM by sybrand_b RSS

    Need Help to understand Character Set

    dbthought
      Hi all,

      Could you please tell me the exact name of the parameter .

      As per my understanding

      Database Character Set is NLS_CHARACTERSET (e.g. AL32UTF8)

      National Character Set is NLS_NCHAR_CHARACTERSET ( e.g. UTF8)


      Please let me know , if my understanding is wrong

      thanks
        • 1. Re: Need Help to understand Character Set
          HU
          I am not sure what you are actually asking.
          Here is an example
          select parameter, value from nls_database_parameters where parameter like '%CHARACTERSET%';
          
          PARAMETER                      VALUE
          ------------------------------ ----------------------------------------
          NLS_CHARACTERSET               WE8ISO8859P1
          NLS_NCHAR_CHARACTERSET         AL16UTF16
          NLS_CHARACTERSET is used for char, varchar2 and clob columns
          NLS_NCHAR_CHARACTERSET is used for nchar, nvarchar2 and nclob columns

          These corresponds to CHARACTER SET and NATIONAL CHARACTER SET from the create database statements.

          Edited by: HU on 2012-05-09 13:28
          • 2. Re: Need Help to understand Character Set
            Fran
            Please, dont copy blogs from other people and make it yours......

            http://oraclespin.wordpress.com/2009/02/02/what-is-the-difference-bw-nls_nchar_characterset-and-nls_nchar_characterset/
            • 3. Re: Need Help to understand Character Set
              dbthought
              Sorry...but I need to know what is difference between

              Database Character Set and National Character Set
              and what are those.

              thanks
              • 4. Re: Need Help to understand Character Set
                HU
                Replying to "Please, dont copy blogs from other people and make it yours......"

                Why do you think I did that?

                Just because the sql's are similar (but not identical)?


                The sql and the result are from a local db, and were written/executed as I wrote the post.
                • 5. Re: Need Help to understand Character Set
                  HU
                  Your database can have two character sets.

                  One (character set) is used for char, varchar2 ...
                  The other (national character set) is used for nchar, nvarchar ...

                  You can use either for any new table/column to fit your needs.


                  If you write about your specific problem, I will try to comment on that.
                  • 6. Re: Need Help to understand Character Set
                    dbthought
                    Hi ,



                    could you please tell me difference between

                    Database Character Set and National Character Set
                    and what are those.


                    thanks
                    • 7. Re: Need Help to understand Character Set
                      Fran
                      The different between NLS_NCHAR_CHARACTERSET and NLS_CHARACTERSET are that NLS_NCHAR_CHARACTERSET defines a value of the National character and NLS_CHARACTERSET defines the Normal character set of the database..


                      @HUB, Don't you think it's much chance, the same phrase, in the same order and the same sentence? casually also a similar query?

                      Edited by: Fran on 09-may-2012 4:55
                      • 8. Re: Need Help to understand Character Set
                        sybrand_b
                        Can you read the Globalization Manual for your unknown version of Oracle please?
                        It will explain the difference.

                        ------------
                        Sybrand Bakker
                        Senior Oracle DBA