In SQL Server changing column varchar(255) nvarchar
Posted
by JD
on Stack Overflow
See other posts from Stack Overflow
or by JD
Published on 2010-04-22T16:49:26Z
Indexed on
2010/04/22
16:53 UTC
Read the original article
Hit count: 309
sql-server
Hi,
I am using SQL server 2008 express and some of our columns are defined as varchar(255). Should I convert these columns to NvarChar(255) or nvarchar(max)?
The reason I ask is I read that nvarchar(255) for unicode characters would actually store 1/2 the number of characters (since unicode characters are 2 bytes) whereas 255 with varchar() would allow me to store 255 characters (or is it 255 - 2 for the offset).
Would there be any performance hits using nvarchar(max)?
JDs
© Stack Overflow or respective owner
