The Datatypes

Hi,
 How do the datatypes CHAR and NCHAR also VARCHAR2 and NVARCHAR2 actually differs. Do all of them takes the same storage space?

If i use English(or any other Single Byte Language) and define a column for a table as xyz char(20), DO I HAVE TO ACTUALLY CHANGE THE WIDTH TO xyz NCHAR(40) if i use KOREAN/JAPANES/CHINESE (or any other Double Byte Language)?

Can't i use CHAR(40)instead? Will there be any corruption of data in this case?

Call to everyone....please help

Thanks in Advance
samir

• Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful