In a database with the database character set of US7ASCII and a national character set of UTF-8,
which datatypes would be capable of storing Unicode data by default?
A.
VARCHAR2
B.
CHAR
C.
NVARCHAR2
D.
CLOB
E.
LONG
which datatypes would be capable of storing Unicode data by default?
In a database with the database character set of US7ASCII and a national character set of UTF-8,
which datatypes would be capable of storing Unicode data by default?
Use of Unicode Data in an Oracle Database
Unicode is an effort to have a unified encoding of every character in every language known to man. It also provides a way to represent privately-defined characters. A database column that stores Unicode can store text written in any language.
Oracle users deploying globalized applications have a strong need to store Unicode data in Oracle databases. They need a datatype which is guaranteed to be Unicode regardless of the database character set.
Oracle supports a reliable Unicode datatype through NCHAR, NVARCHAR2, and NCLOB. These datatypes are guaranteed to be Unicode encoding and always use character length semantics. The character sets used by NCHAR/NVARCHAR2 can be either UTF8 or AL16UTF16, depending on the setting of the national character set when the database is created. These datatypes allow character data in Unicode to be stored in a database that may or may not use Unicode as database character set.