Data Analysis/SQL

MS SQL nchar vs nvarchar

AubreyJeong 2019. 1. 29. 15:03

nchar and nvarchar (Transact-SQL)


Character data types that are either fixed-length, nchar, or variable-length, nvarchar. Starting with SQL Server 2012 (11.x), when a Supplementary Character (SC) enabled collation is used, these data types store the full range of Unicode character data and use the UTF-16 character encoding. If a non-SC collation is specified, then these data types store only the subset of character data supported by the UCS-2 character encoding.