Install New Unicode Character Set in Oracle

Locale Builder is an utility to view, modify, or define locale-specific data. As well as to create your own formats for language, territory, character set, and linguistic sort.(I will discuss how to create .nlb(binary file) from .nlt(text file)).


.nlt file looks like this lx22713.nlt and there is also boot.nlt file lx0boot.nlt.

1. Choose Tools > Generate NLB or click the Generate NLB icon in the left side bar.
2. Click Browse to find the directory where the NLT files(containing boot file) are located and click ok.
   

  3.Copy these .nlb files and paste them into $ORACLE_HOME/nls/data directory.

That is all,new Unicode character set is installed.

Now to use this Unicode character:

1. Run->regedit->HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_...-> find and modify NLS_LANG value to AMERICAN_AMERICA.GEO8BOGALTWIN(this name is found in .nlt file  in a  <name> tag)

2.Open PL/SQL Developer->choose Tools->Preferences...->Fonts->Select-> and then choose Font:.