Differences between GaussDB 100 VARCHAR() and NVARCHAR()

TingtingGG · Created Jul 31, 2019 13:23:53

Hey there!

Differences between VARCHAR() and NVARCHAR()

Definition

nvarchar(n): Variable length Unicode character data containing n characters. The value of n must be between 1 and 4,000. The size of a byte is twice the number of characters entered. The length of the entered data character can be zero.

varchar(n): A variable-length and non-Unicode character data whose length is n bytes. n must be a value between 1 and 8,000. The storage size is the actual length of the byte of the input data, not n bytes. The length of the entered data character can be zero.

Differences

In storage mode, nvarchar is stored by [character], while varchar is stored by [byte]. In terms of storage capacity, varchar saves space because the storage size is the actual length of bytes, while nvarchar is dual-byte storage. If the stored contents are English characters and no other language symbols such as Chinese characters are used, you are advised to use varchar.

nvarchar is used for Chinese characters, because nvarchar uses Unicode encoding, that is, unified character encoding standard, which reduces the occurrence probability of garbled characters. If your project may involve conversion between different languages, you are advised to use nvarchar.

TingtingGG · Created Jul 31, 2019 13:23:53

Hey there!

Differences between VARCHAR() and NVARCHAR()

Definition

nvarchar(n): Variable length Unicode character data containing n characters. The value of n must be between 1 and 4,000. The size of a byte is twice the number of characters entered. The length of the entered data character can be zero.

varchar(n): A variable-length and non-Unicode character data whose length is n bytes. n must be a value between 1 and 8,000. The storage size is the actual length of the byte of the input data, not n bytes. The length of the entered data character can be zero.

Differences

In storage mode, nvarchar is stored by [character], while varchar is stored by [byte]. In terms of storage capacity, varchar saves space because the storage size is the actual length of bytes, while nvarchar is dual-byte storage. If the stored contents are English characters and no other language symbols such as Chinese characters are used, you are advised to use varchar.

nvarchar is used for Chinese characters, because nvarchar uses Unicode encoding, that is, unified character encoding standard, which reduces the occurrence probability of garbled characters. If your project may involve conversion between different languages, you are advised to use nvarchar.

Differences between GaussDB 100 VARCHAR() and NVARCHAR()

Best answer

Third Party’s Trade Secret

My Followers

Enterprise

Consumer

Corporate

Carriers

Differences between GaussDB 100 VARCHAR() and NVARCHAR()

Best answer

Third Party’s Trade Secret

My Followers