alter column

  • 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?

  • 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.

  • 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