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.
what is the difference b/w text,char,varchar and ntext,nchar,nvarchar in sqlserver ?
thanks.
|
||||
difference in datatypessachin_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