SQL: Differences between CHAR NCHAR VARCHAR VSRCHAR2 NVARCHAR
Difference Between CHAR NCHAR VARCHAR NVARCHAR VARCHAR2
NCHAR and NVARCHAR Can store Unicode Characters.
Char VARCHAR can not store Unicode character.
CHAR and NCHAR are fixed length data type that means this is gonnna use the complete space that we have declared.
VARCHAR, NVARCHAR and VARCHAR2 are variable length data types.
VARCHAR and VARCHAR2 - VARCHAR occupy space for NULL records as well and It can store up to 2000 bytes of data
as compare to VARCHAR2 i.e 4000 bytes of data.
#GoLearningPoint
For Interview questions and other topics -
https://tipsfororacle.blogspot.com/
