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)

Explain Active/Active and Active/Passive cluster configurations

2 Answers  

---

1.How to check the backup file details if we do not have access to that folder 2.how to check the backup file size without connecting to the folder

3 Answers   CarrizalSoft Technologies, IBM,

---

what is bit datatype? : Sql server database administration

0 Answers  

---

We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

0 Answers   Amdocs, Apps Associates,

---

What is the difference between Stored Procedure , Function and Package, 1. how many blocks in Package and what are they.

5 Answers   IBM,

---

What is the difference between truncate and delete statement?

6 Answers   CarrizalSoft Technologies, CTS,

---

what are constraints? Explain different types of constraints? : Sql server database administration

0 Answers  

---

How ssrs maintain security?

0 Answers  

---

What are distinctive joins find as a part of sql?

0 Answers  

---

What is difference between primary key and foreign key?

0 Answers  

---

DIFFERENCE BETWEEN SQL SERVER 2005 and 2008

2 Answers   ADP,

---

What are the fixed server level roles? : sql server security

0 Answers  

---