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.

'Data Analysis > SQL' 카테고리의 다른 글

데이터베이스 튜닝  (1) 2019.03.05
[w3schools] SQL ③ - JOIN series  (0) 2019.01.28
[w3schools] SQL Study②  (0) 2019.01.25
[w3schools] SQL Study①  (0) 2019.01.22