...

difference in datatypes

sachin_himcs
04-11-2006, 08:13 AM
i want to know

what is the difference b/w text,char,varchar and ntext,nchar,nvarchar in sqlserver ?


thanks.

Roelf
04-11-2006, 09:06 AM
char: fixed length column, storage size is defined size, regardless of entered size
max 8000 bytes
varchar: variable length column, storage size is equal to size of entered data
max 8000 bytes
text: variable length column storage size equal to size of entered data
max 2,147,483,647 bytes

above are all for storing ascii characters

prefixed with n, the fields are meant to store Unicode characters. All max amounts can be divided by 2



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum