Char nchar varchar nvarchar differences

Source: Internet
Author: User



Fixed Length, non-UNICODE character data, length is n Bytes. The value range of N is 1 to 8,000, and the storage size is n Bytes. Char SQL 2003 is synonymous with character.


Variable Length, non-UNICODE character data. The value range of N is 1 to 8,000. Max indicates that the maximum storage size is 2 ^ 31-1 bytes. The storage size is the actual length of the input data plus two bytes. The length of the input data can be 0 characters. In the SQL-2003, The varchar is Char varying or character varying.


Unicode character data of a fixed length of n characters. The N value must be between 1 and 4,000 (inclusive ). The storage size is twice n Bytes. The SQL-2003 synonym for nchar is national char and national character.


Variable-length UNICODE character data. N is between 1 and 4,000 (inclusive ). Max indicates the maximum storage size is 2 ^ 31-1 bytes. The storage size is twice the number of characters entered + 2 bytes. The length of the input data can be 0 characters. The SQL-2003 synonyms for nvarchar are national char varying and National Character varying.


Char, varchar

Up to 8000 English letters and 4000 Chinese Characters

Nchar, nvarchar

It can store 4000 characters, regardless of English or Chinese Characters


Char, nchar

Fixed Length, fast speed, large space occupation, need to be processed

Varchar and nvarchar

Variable Length, slow speed, small space, no processing required


A fixed length is a fixed length. when the length of the input data does not reach the specified length, it is automatically filled with English spaces to make the length reach the corresponding length.

Variable-length character data is not filled with spaces. The exception is that text is also variable-length.


1. Char. It is very convenient for Char to store fixed-length data, and the indexing efficiency of char fields is high. For example, if char (10) is defined, no matter whether the data you store reaches 10 bytes, it takes up 10 bytes of space. If the space is insufficient, it is automatically filled with spaces. Therefore, trim () may be used multiple times during reading ().

2. varchar. Variable-length data is stored, but the storage efficiency is not as high as char. If the possible value of a field is not fixed, we only know that it cannot exceed 10 characters. It is the most cost-effective to define it as varchar (10. The actual length of the varchar type is the actual length of its value plus 1. Why "+ 1? This byte is used to save the actual length.From the perspective of space, it is appropriate to use varchar; from the perspective of efficiency, char is suitable, and the key is to find a trade-off point based on the actual situation.

3. nchar, nvarchar, and ntext. The three names are named N more than the first three ". It indicates that characters of the Unicode data type are stored. We know that only one byte is required for English characters, but there are many Chinese characters and two bytes are required for storage. It is easy to cause confusion when both English and Chinese characters exist, unicode Character Set is generated to solve the incompatibility problem of character sets. All its characters are expressed in two bytes, that is, English characters are also expressed in two bytes. The length of nchar and nvarchar is between 1 and 4000. Compared with Char and varchar, nchar and nvarchar can store up to 4000 characters, whether in English or Chinese. Char and varchar can store up to 8000 English and 4000 Chinese characters. It can be seen that when using nchar and nvarchar data types, you do not have to worry about whether the entered characters are English or Chinese characters, which is more convenient, but there is some loss in the amount of stored English hours.

Therefore, in general, if it contains Chinese characters, use nchar/nvarchar. If it contains English letters and numbers, use Char/varchar.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.