AW: Data Types

[Stefan Jahnke]

Hi Santosh,

 

VARCHAR and VARCHAR2 are pretty much the same, but Oracle has them both to be compatible ANSI types.

The N prefix indicates that you can store multibyte data in these fields (like Unicode). The reason behind it is,

that you can either have the whole database be Unicode based or you don't and then you'll have to use the N

prefixed datatypes in order to have a Unicode / non-Unicode mix within tables.

 

Regards,

Stefan

-----Ursprüngliche Nachricht-----
Von: Santosh Varma [mailto:[EMAIL PROTECTED]]
Gesendet: Freitag, 21. Juni 2002 08:23
An: Multiple recipients of list ORACLE-L
Betreff: Data Types

i wanted to know the exact difference between the following data types ->

 

NCHAR

NVARCHAR2

VARCHAR2

VARCHAR

Thanks and regards,

Santosh