SQL Server - Differences of CHAR and NCHAR in SQL Server Transact-SQL

Home > SQL Server

Differences of CHAR and NCHAR in SQL Server Transact-SQL

Q

What Are the Differences between CHAR and NCHAR in SQL Server Transact-SQL?

✍: FYIcenter.com

A

Both CHAR and NCHAR are fixed length data types in Transact-SQL. But they have the following main differences:

CHAR stores characters based on the code page with 1 byte per character most of the time.
NCHAR stores characters using Unicode character set with 2 bytes per character most of the time.
CHAR(n) specifies a length of n bytes by default.
NCHAR(n) specifies a length of n characters by default.

⇒Variables and Data Types in SQL Server Transact-SQL

⇒⇒SQL Server Transact-SQL Tutorials

2017-04-04, 641👍, 0💬

Binary String Data Types in SQL Server Transact-SQL
What are binary string data types supported in SQL Server Transact-SQL? Binary string data types are used to hold binary character strings. There are 3 binary string data types supported in SQL Server Transact-SQL: 1. BINARY - Used to hold binary strings of a fixed length, specified in the format of... 2017-04-04, 756👍, 0💬

Unicode Character Data Types in SQL Server Transact-SQL
What are Unicode character string data types supported in SQL Server Transact-SQL? Unicode character string data types are used to hold Unicode character strings. There are 3 Unicode character string data types supported in SQL Server Transact-SQL: 1. NCHAR (or NATIONAL CHAR, or NATIONAL CHARACTER) ... 2017-04-08, 754👍, 0💬

Differences of CHAR and VARCHAR in SQL Server Transact-SQL
What Are the Differences between CHAR and VARCHAR in SQL Server Transact-SQL? CHAR and VARCHAR are both used to store code page based 1-byte character strings in Transact-SQL. But they have the following main differences: CHAR(n) stores character strings with a fixed length, n bytes, storage format.... 2017-04-04, 713👍, 0💬

Differences of CHAR and NCHAR in SQL Server Transact-SQL
What Are the Differences between CHAR and NCHAR in SQL Server Transact-SQL? Both CHAR and NCHAR are fixed length data types in Transact-SQL. But they have the following main differences: CHAR stores characters based on the code page with 1 byte per character most of the time. NCHAR stores characters... 2017-04-04, 642👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.