What is the difference between nvarchar2 and varchar2

If you try to insert a value that exceeds the specified length, then Oracle returns an error. This maximum must be at least 1 byte, although the actual string stored is permitted to be a zero-length string ''. A character is technically a code point of the database character set. To ensure proper data conversion between databases with different character sets, you must ensure that VARCHAR2 data consists of well-formed strings.

If it is used to store English, only 10 characters can be stored. Byte represents the length of the column in bytes, and char represents the length of the column in characters.

A variable length character type with a character set attribute that has the maximum length. It is twice as long as the al16utf16 character set and three times as long as the utf8 character set.

Its maximum length depends on the character set and the upper limit is bytes. Well, the above is the whole content of this article. 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: info-contact alibabacloud.

A comprehensive suite of global cloud computing services to power your business. These two types are more suitable for storing Chinese Difference: 1. Related Keywords: difference between replace and translate in oracle oracle pl sql array of varchar2 types of functions in oracle types of queries in oracle default value of number datatype in oracle examples of sql queries in oracle how to get difference of two dates in php.

Oracle database, numbers Force 2 decimal places to display An array of Oracle 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.