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

17 comments:

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

    ReplyDelete
  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

    ReplyDelete
  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: vguruonline@gmail.com

    ReplyDelete
  4. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

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

    iOS Training in Chennai

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

    ReplyDelete
  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 info@bravetechnologies.in. ERP in Chennai | ERP Providers in Chennai

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

    ReplyDelete
  9. this blog providing good information To learn NodeJS Training contact: iwebworldinfo@gmail.com

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

    ReplyDelete
  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

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

    ReplyDelete
  13. this blog providing good information To learn

    HTML PHP NodeJS Hadoop Training in Tarnaka Hyderabad

    contact: infotechiesguild@gmail.com


    ReplyDelete