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, 6146👍, 0💬

Popular Posts:

What is Concern in AOP? gA concern is a particular goal, concept, or area of interesth There are m...

Do You Know the Book "JUnit in Action"? You should know this book. It received some good reviews. Ti...

Enable ASP.NET polling using “web.config” file Now that all our database side is configured in order...

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

How do you locate the first X in a string txt? A) txt.find('X'); B) txt.locate('X'); C) txt.indexOf(...