Varchar2 - Stores variable length character up to a maximum of 4000 characters. variable length character data is character data in which values in different rows can have a different number of characters.
Eg: firstname VARCHAR2(30)
Char - stores fixed-length character data up to a maximum of 2000 characters. Fixed-length character data is character data in which the data values for different rows all have the same number f characters.
Eg: class CHAR(2)
NVarchar2 and Nchar - Use if input data in character set is data other than standard English. (Address 256 character limitation of ASCII coding)
Eg: firstname VARCHAR2(30)
Char - stores fixed-length character data up to a maximum of 2000 characters. Fixed-length character data is character data in which the data values for different rows all have the same number f characters.
Eg: class CHAR(2)
NVarchar2 and Nchar - Use if input data in character set is data other than standard English. (Address 256 character limitation of ASCII coding)
No comments:
Post a Comment