.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

What Are the Differences between CHAR and NCHAR

Q

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

✍: 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-06-25, 6531👍, 0💬

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML