asp.net c# sql 2008
Character Data TypeVarchar - Non-Unicode Data NVarchar - Unicode DataMaximum Length Varchar - 8,000 bytesNVarchar - 4,000 bytes
ISO synonyms for nvarchar are national char varying and national character varying.
Differences :1 Character Data TypeVarchar - Non-Unicode Data NVarchar - Unicode Data2 Character Size Varchar - 1 byteNVarchar - 2 bytes3 Maximum Length Varchar - 8,000 bytesNVarchar - 4,000 bytes4 Storage Size Varchar - Actual Length (in bytes)NVarchar - 2 times Actual Length (in bytes)
thanks Rohit for nice information.
Post a Comment
4 comments :
Character Data Type
Varchar - Non-Unicode Data
NVarchar - Unicode Data
Maximum Length
Varchar - 8,000 bytes
NVarchar - 4,000 bytes
ISO synonyms for nvarchar are national char varying and national character varying.
Differences :
1 Character Data Type
Varchar - Non-Unicode Data
NVarchar - Unicode Data
2 Character Size
Varchar - 1 byte
NVarchar - 2 bytes
3 Maximum Length
Varchar - 8,000 bytes
NVarchar - 4,000 bytes
4 Storage Size
Varchar - Actual Length (in bytes)
NVarchar - 2 times Actual Length (in bytes)
thanks Rohit for nice information.
Post a Comment