Interested to Buy Any Domain ? << Click Here >> for more details...
Difference Between varchar and nvarchar datatype?
- 3 Answers
- 14061 Views
- Satyam, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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
| Is This Answer Correct ? | 37 Yes | 7 No |
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:
| Is This Answer Correct ? | 5 Yes | 3 No |
Answer / munnabhaibcs
nvarchar means Your National Language data(font)
| Is This Answer Correct ? | 6 Yes | 15 No |
How to perfor If the table running time is taking 2hours and table is having 10 rows in it?
what is the difference between Delete and Truncate
4 Answers CarrizalSoft Technologies, Geo Research Centre,
How many instances per computer are there in sql server 2000?
What is the fillfactor concept in indexes?
Do comments need to go in a special place in sql server 2005?
One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d f f g h
What is the fastest way to permanently delete a 1 million row table named customers?
What are different types of raid configurations? : SQL Server Architecture
How to edit table in sql server 2017?
What is an execution plan?
How do you delete duplicate rows in sql server?
How to delete duplicate rows in sql server?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
