answersLogoWhite

0

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:
User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

What is the difference between char and varchar2 in dbms?

no diff between varchar and varchar2 char store only chacter type but varchar2 store variable chacters. also varchar2 shirinks the space if not fully filled but char cant.


What is the difference between varchar and nvarchar?

The difference between varchar and nvarchardatatypes is that Nvarchar stores UNICODE data. If you have requirements to store UNICODE or multilingual data, nvarcharis your choice. Varchar stores ASCII data and should be your data type of choice for normal use.


How do you create a table in oracle9i?

create table EMP( E_NAME VARCHAR2(10) E_LOC VARCHAR2(10) E_SAL NUMBER(5.2) E_DEPT VARCHAR2(10));


Maximum length of a varchar field in SQL Server?

12,500 is the maximum length of a varchar field. The nVarchar field has the same limitation however you will use twice the data store space with an nVarchar as it is effectively the same as a varchar with the exception that it will store data required for international character sets. If you support a multi-language system then you will want to use a nVarchar character type for these fields.


What does data type represents?

Datatype represents the type of data like integer, varchar2 etc. Example name varchar2(20) it denotes that name is an attribute of character and size is 20 characters .


How do you create an employee table with the uses of primary key?

CREATE TABLE EMPLOYEE (EMP_ID NUMBER(10) PRIMARY KEY,NAME VARCHAR2(100),EMAIL_ID VARCHAR2(50) UNIQUE);Hope it helped.SP.


What is the syntax of oracle dynamic sql?

The syntax for dynamic sql is For example if you want to create table at run time then syntax is Declare V-string varchar2(900); begin V_string:='create table ORACLE (empno number,ename varchar2(90)'); execute immediate V_string; end; /


What is difference between as on and as at?

difference between as on and as at


What are the differences between California and Florida?

What is the difference between Florida and California What is the difference between Florida and California


What is the difference between physician and doctor?

what's the difference between physician and doctorwhat's the difference between physician and doctor what's the difference between physician and doctor


What difference between paging?

Difference between paging and what?


What is the difference between difference and difference?

just difference