Monday, January 17, 2011

What is Database Character Set and National Character Set (NCHAR)

What is Database Character Set?

Character sets are how we store data,A Character set is specified when creating a database, and your choice of character set determines what languages can be represented in the database. This choice also influences how you create the database schema and develop applications that process character data. It also influences interoperability with operating system resources and database performance.

When processing characters, computer systems handle character data as numeric codes rather than as their graphical representation. For instance, when the database stores the letter "A", it actually stores a numeric code that is interpreted by software as that letter.

A group of characters (for example, alphabetic characters, ideographs, symbols, punctuation marks, control characters) can be encoded as a coded character set. A coded character set assigns unique numeric codes to each character in the character repertoire.

What is National Character Set (NCHAR)

A national character set is an alternate character set that enables you to store Unicode character data in a database that does not have a Unicode database character set. Other reasons for choosing a national character set are:

  • The properties of a different character encoding scheme may be more desirable for extensive character processing operations
  • Programming in the national character set is easier


  1. Thanks for sharing this valuable information to our vision. You have posted a trust worthy blog keep sharing.
    Oracle DBA Training in Chennai|Oracle Training Institutes in Chennai

  2. The strategy you have posted on the oracle hepled me to get into the next level of this technology and had lot of informations in it.
    oracle training in chennai | oracle training institutes in chennai

  3. obiee training in Hyderabad
    we are offering best Obiee online training with work support and job assistance and high quality training facilities and well expert faculty
    for other details and register your demo contact
    obiee online training
    Institute : Vguru Online Trainings
    Contact number: +91-9885681705
    Email Id:

  4. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer
    LinkedIn profile -
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, OAF, ADF, SQL, PL/SQL, D2K at | +91 - 9581017828.

  5. Wonderful blog.. Thanks for sharing informative blog.. its very useful to me..

    iOS Training in Chennai

  6. Great information. Thank you for Sharing.(ERP) Enterprise Resource Planning Software Solutions in Chennai.
    ERP Software Company Chennai | ERP Software Development Chennai

  7. Thank you for this valuable information. I have got some important suggestions from it. I'm working in Brave Technologies Private Limited. We provides lowest price of ERP Software for our clients. Contact us on ERP in Chennai | ERP Providers in Chennai

  8. The best thing is that your blog really informative thanks for your great information!
    erp provider in chennai

  9. this blog providing good information To learn NodeJS Training contact:

  10. this blog providing good information To learn NodeJS AngularJS MongoDB Training contact:

  11. Thanks a lot very much for the high quality and results-oriented help.
    I won’t think twice to endorse your blog post to anybody who wants
    and needs support about this area.

    java training in chennai

    java training in bangalore

  12. Your website content nice nice and interesting to observe.
    jobbörse Neunkirchen

  13. this blog providing good information To learn

    HTML PHP NodeJS Hadoop Training in Tarnaka Hyderabad


  14. Great post. Wonderful information and really very much useful. Thanks for sharing and keep updating.
    Best Summer Courses for School Students in Chennai | Best Summer Courses for School Students in Velachery

  15. I simply wanted to write down a quick word to say thanks to you for those wonderful tips and hints you are showing on this site. AWS Training in chennai

  16. Nice and good article. It is very useful for me to learn and understand easily. Thanks for sharing your valuable information and time. Please keep updating...
    Best IT Training Institute in Chennai |Best IT Training Institute in Velachery

  17. Nice blog. Thank you for sharing. The information you shared is very effective for learners I have got some important suggestions from it…
    Microsoft Excel Summer Course training Institute in Chennai| Microsoft Excel Summer Course training Institute in St. Thomas Mount

  18. Impressive blog with lovely information. Really very useful article for us thanks for sharing such a wonderful blog...
    Best VMware Training Institute in Chennai | Best VMware Training Institute in Velachery

  19. It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me

    Best Cloud Computing Training Academy in Kanchipuram

  20. Thanks for this grateful information. all this information is very important to all the users and can be used good at all this process.

    Best Web Designing Training Academy in Kanchipuram

  21. Your article was so impressive and informative. Its very interesting to read. Thanks for sharing,
    Best web design Training Institute in Kanchipuram

  22. Excellent Blog very imperative good content, this blog is useful to beginners.
    Best Selenium Automation Course Training Institute in kanchipuram|