Difference Between varchar and nvarchar datatype?
Answer Posted / p.pradeepa
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.
If the National CS is of variable width CS (some characters
are represented by 1 byte some by 2 bytes as in UTF8 ) then
NVARCHAR2(30) stores 30 bytes.
The maximum column size allowed is 4000 bytes.
Ex: CREATE TABLE tab1 (col1 NVARCHAR2(2000)); will create a
table with one NVARCHAR2 column of 2000 characters in
length (stored as 4000 bytes because each character takes
two bytes) using JA16EUCFIXED as the national character
set:
Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
How many types of cursor type are there?
How can you find out which stored procedures are recompiling?
How to disable triggers using "disable trigger"?
What command is used to delete a table from the database in the sql server and how?
Explain trigger and its types?
How to verify a user name with sqlcmd tool?
What happens if null values are involved in boolean operations?
What are different types of statements that are supported by sql?
What is sql server profiler?
What causes index fragmentation?
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
Create and insert into temp table in sql server?
What are functions in the sql server?
Explain sql server authentication modes?
Call by value and call by reference in procedure and function, with NOCOPY.