What Are the Differences between CHAR and NCHAR

What Are the Differences between CHAR and NCHAR? - Oracle DBA FAQ - Understanding SQL Basics

✍: FYIcenter.com

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-06-25, 6658👍, 0💬

Popular Posts:

How can I include comments in HTML? An HTML comment begins with "...

What Does a HTML Document Look Like? A HTML document is a normal text file with predefined tags mixe...

Can Multiple Cursors Being Opened at the Same Time? - Oracle DBA FAQ - Working with Cursors in PL/SQ...

How to create arrays in JavaScript? We can declare an array like this var scripts = new Array(); We ...

What is Service Oriented architecture? “Services” are components which expose well defined interface...