database - What are NLS Strings in Oracle SQL? -


what nls strings in oracle sql shown difference between char , nchar varchar2 , nvarchar2 data types ? thank you

every oracle database instance has 2 available character set configurations:

  1. the default character set (used char, varchar2, clob etc. types)
  2. the national character set (used nchar, nvarchar2, nclob, etc. types)

because default character set configured character set doesn't support full range of unicode characters (such windows 1252), that's why oracle provides alternate character set configuration well, is guaranteed support unicode.

so let's database uses windows-1252 default character set (not i'm recommending it), , utf-8 national (or alternate) character set...

then if have table column don't need support kinds of weird unicode characters, can use type such varchar2 if want to. , doing so, may saving space.

but if have specific need store , support unicode characters, specific instance, column should defined nvarchar2, or other type uses national character set.

that said, if database's default character set character set supports unicode, using nchar, nvarchar2, etc. types not necessary.

you can find more complete information on topic here.


Comments

Popular posts from this blog

twig - Using Twigbridge in a Laravel 5.1 Package -

jdbc - Not able to establish database connection in eclipse -

firemonkey - How do I make a beep sound in Android using Delphi and the API? -