Multitier Unrestricted Multilingual Support Scenario in a Multitier Configuration
The database, the application server, and each client use the AL32UTF8 character set. This eliminates the need for character conversion even though the clients are French, German, and Japanese.
You can store Unicode characters in an Oracle database in two ways.
You can create a Unicode database that enables you to store UTF-8 encoded characters as SQL
CHAR datatypes (
If you prefer to implement Unicode support incrementally or if you need to support multilingual data only in certain columns, then you can store Unicode data in either the UTF-16 or UTF-8 encoding form in SQL
NCHAR datatypes (
NCLOB). The SQL
NCHAR datatypes are called Unicode datatypes because they are used only for storing Unicode data.