February 25, 2011 at 2:05 am
Hi,
Suppose i have a Nvarchar column which as the following characteristics:
nvarchar(20)
This column as data inside it.
Some data sample are:
0012342123
345444455423452
235555222222222
If i change this column from nvarchar(20) to nvarchar(25)
1) Will the data already inside the column be changed in size because of this?
2) Will new data that i insert through apps nedd to be diferente because of the size change?
In other words, shoud i expect some kind of problems because of changing the size of this column?
February 25, 2011 at 2:09 am
As you are using a varchar it changing the size will not make a difference as the size used is variable depending on the data.
The storage size is the length of the data + 2 bytes
I would question the need to use a unicode datatype though going by the sample data you provided.
February 25, 2011 at 2:12 am
I question too...
It was not my decision. It was a decision from other person...
I think that varchar is good, no need to have unicode columns in my case (nvarchar)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply