Thursday, May 19, 2011

unicode and non-unicode data type in sql server 2008

nchar, nvarchar

char, varchar

 

Basically unicode data type requires a bit more space to store than non-unicode datatype. however, it could save you tons of time when it comes to the data type conversion. From the perspective of SSIS ETL processes, lots of source data are in unicode format (excel , dbf) and it would get into the unicode datatype columns a lot easiler than the non-unicode ones.

No comments:

Post a Comment