Differences between CHAR and NCHAR in Oracle
Q
What Are the Differences between CHAR and NCHAR in Oracle?
✍: FYIcenter.com
A
Both CHAR and NCHAR are fixed length character data types. But they have the following differences:
- CHAR's size is specified in bytes by default.
- NCHAR's size is specified in characters by default. A character could be 1 byte to 4 bytes long depending on the character set used.
- NCHAR stores characters in Unicode.
2016-10-17, 499👍, 0💬
Related Topics:
