Difference between CHAR and NCHAR in Oracle

Differences between CHAR and NCHAR in Oracle.

Nchar is used to store fixed length Unicode data. It is often used to store data in different languages. CHAR on the other hand is store fixed length character data.
When data is stored using CHAR, it takes n bytes while NCHAR takes 2n bytes.
CHAR accepts up to 8000 characters while NCHAR accepts 4000 characters.

Oracle - Differences between CHAR and NCHAR in Oracle - Feb 07, 2010 at 14:20 PM by Shuchi Gauri

Differences between CHAR and NCHAR in Oracle.

NCHAR allow storing of Unicode data in the database. One can store Unicode characters regardless of the setting of the database characterset

Oracle - Differences between CHAR and NCHAR in Oracle - June 27, 2009 at 11:00 AM

Differences between CHAR and NCHAR in Oracle.

CHAR and NCHAR are character data types which and have a fixed length.

However, CHAR has a specified size in bytes by default and NCHAR has a size specified in characters by default. (NCHAR stores characters in Unicode)

A character could be 1 byte to 4 bytes long depending on the character set used.

Also read

Oracle object datatypes

Object data types are user defined data types. Both column and row can represent an object type................

What is Varrays?

Varrays, variable length array is quite similar to array of C++ or Java. It has fixed upper-bound size that has to be specified while it is declared..........

What are LOB datatypes?

The LOB datatypes such as BLOB, CLOB, NCLOB and BFile can store large blocks of unstructured data such as graphics, image, video clips etc.............

<<Previous  Next>>

Write your comment - Share Knowledge and Experience