question

Shaner avatar image
Shaner asked

Alter size of varchar Column

I altered the size of a varchar column from 20 to 30. The alter worked ok but it still only allows me to insert or update 20 characters. What am I missing??

computed-column
3 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Can you post the table script please?
0 Likes 0 ·
can you post your table definition, and the code you are using to insert or update...
0 Likes 0 ·
Discovered my own problem. I forgot to update the Triggers. Thanks anyway
0 Likes 0 ·
Shaner avatar image
Shaner answered

Discovered my own problem. I forgot to update the Triggers. Thanks anyway

1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Mark this answer as correct then - maybe someone in the future will see this, and this will save them some searching (just before they facepalm themselves in a majorly epic manner)
2 Likes 2 ·
mabc360 avatar image
mabc360 answered

Are you sure that the update worked?

Can you generate the script of the table to see if the change has been commited?

1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Discovered my own problem. I forgot to update the Triggers. Thanks anyway
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.