What is difference between Varchar2 and Nvarchar2?…
Varchar2(s) is used to define a variable length character of maximum size s. Nvarchar2: Same as VARCHAR2 except that the column stores values in the National CS ie you can store values in Bangla if your National CS is BN8BSCII .If the National CS is of fixed width CS (all characters are represented by a fixed byte say 2 bytes for JA16EUCFIXED) then NVARCHAR2(30) stores 30 Characters.
