Interested to Buy Any Domain ? << Click Here >> for more details...
Difference Between varchar and nvarchar datatype?
- 3 Answers
- 14175 Views
- Satyam, I also Faced
- E-Mail Answers
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
Can you edit the .rdl code associated with a linked report?
What are wait types?
Explain what is the difference between union and union all?
How to create an index on a view?
Explain what are the different index configurations a table can have?
How to change the password of a login name in ms sql server?
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
Explain for xml explicit mode?
What is attribute? : sql server analysis services, ssas
How to call a function from a stored procedure in SQL Server ?
What is dbcc? Give few examples.
What are the tables in sql?
What is store procedure? How do they work? When do you use?
What is normalization? Explain different forms of normalization?
Mention the different types of triggers?
