Answer / muhammadrashidmughal

The difference in varchar and nvarchar datatypes is
simple. Nvarchar stores UNICODE data. If you have
requirements to store UNICODE or multilingual data,
nvarchar is your choice. Varchar stores ASCII data and
should be your data type of choice for normal use

Answer / 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:

Answer / munnabhaibcs

nvarchar means Your National Language data(font)

How do I view views in sql server?

0 Answers  

---

Can you explain some of the DTS problems?

1 Answers   UBS, Wipro,

---

How to convert binary strings into integers in ms sql server?

0 Answers  

---

can anyone explain me the concept of Serialization in Detail and Clear? plz its urgent i have interview on friday (15th feb)

1 Answers  

---

What is a dbms wizard?

0 Answers  

---

I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

0 Answers   HCL, Wipro,

---

Which are the important points to note when multilanguage data is stored in a table?

0 Answers  

---

What is dknf in normalization form?

0 Answers  

---

Explain following error properties?

0 Answers  

---

MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE

2 Answers   IBM, TCS,

---

How to create a dynamic cursor with the dynamic option?

0 Answers  

---

Explain left outer join and right outer join?

0 Answers  

---