alter column

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » alter column

alter column

Rate Topic

Display Mode

Topic Options

Author

Message

river1

Posted Friday, February 25, 2011 2:05 AM

Say Hey Kid

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 6:56 AM
Points: 679, Visits: 953

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?

Post #1069455

steveb.

Posted Friday, February 25, 2011 2:09 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 10:07 AM
Points: 2,802, Visits: 7,107

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.

Post #1069456

river1

Posted Friday, February 25, 2011 2:12 AM

Say Hey Kid

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 6:56 AM
Points: 679, Visits: 953

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)

Post #1069458

« Prev Topic | Next Topic »

Permissions