SQL Server re-learning (1) The difference between--varchar, nvarchar, and Char

SQL Server can not be lost, review;

varchar (n) Length n bytes of variable-length, non-Unicode character data. n must be a numeric value between 1 and 8,000. Storage size is the actual length of bytes of input data, not n bytes. nvarchar (n) contains a variable-length Unicode character data of n characters. The value of n must be between 1 and 4,000. The storage size of bytes is twice times the number of characters entered. Two fields have field values: me and coffee. The varchar field takes up 2x2+6=10 bytes of storage, and the nvarchar field occupies 8x2=16 bytes of storage space.  
 If the field value is only English can choose varchar, In the case where there are more double-byte (Chinese, Korean, and so on) characters in the field value, the   
 
 

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

SQL Server re-learning (1) The difference between--varchar, nvarchar, and Char