Collections:
Unicode Character Data Types in SQL Server Transact-SQL
What are Unicode character string data types supported in SQL Server Transact-SQL?
✍: FYIcenter.com
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) - Used to hold Unicode character strings of a fixed length specified in the format of NCHAR(n), where n defines the string length as number of characters. The maximum length of VARCHAR is 4,000 Unicode characters.
The storage size of VARCHAR(n) is fixed to 2*n bytes, regardless of the length of the string value. Each Unicode character is stored in UTF-16 2-byte encoding.
2. NVARCHAR (or NATIONAL CHAR VARYING or NATIONAL CHARACTER VARYING) - Use to hold Unicode character strings of variable lengths, specified in the format of NVARCHAR(n), where n defines the string length as number of characters. The maximum length of NVARCHAR is 4,000 Unicode characters.
The storage size of NVARCHAR(n) is flexible up to 2*n+2 bytes, depending on the length of the string value. The extra 2 bytes are used to store the length of the string value.
3. NTEXT (or NVARCHAR(MAX), or NATIONAL TEXT) - Use to hold Unicode character strings of very large lengths. NTEXT uses the CLOB (Character Large OBject) technology to store string values. NTEXT can store string values of variable lengths up to 2^30-1 (1,073,741,823) characters.
Here are some good examples of Unicode character string values:
PRINT N'Hello! '; -- NCHAR(10) PRINT N'Hello!'; -- NVARCHAR(10) PRINT CAST(N'Hello!' AS BINARY(10)); ---------------------- Hello! Hello! 0x480065006C006C006F00
⇒ Differences of CHAR and NCHAR in SQL Server Transact-SQL
⇐ Single-Byte Character Data Types in SQL Server Transact-SQL
2017-04-08, 1834🔥, 0💬
Popular Posts:
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...