Committing a changed varchar column adds collation.

Early Access Program for SQL Source Control

Moderators: Chris Auckland, David Atkinson, sherr

Committing a changed varchar column adds collation.

Postby Håkan B » Fri Mar 05, 2010 10:48 am

I changed a varchar column to be wider and then committed the change to subversion.
When I looked at the script I saw that it had added the Collation on the column I've changed.
That's not a wanted behavior on my behalf. If it should remain it needs to be configurable so it can be turned off.
Håkan B
Posts: 7
Joined: Wed Feb 24, 2010 5:42 pm

Postby Chris Auckland » Wed Mar 10, 2010 2:19 pm

Thanks for your post.

Can I ask how you originally added the table without the collation to subversion? The reason I ask is because SQL Source control will include the column collation when it adds the new object.

There isn't currently an option to ignore the collations, but there isn't any reason why we couldn't add it to a future version if enough people would find it useful.
Chris Auckland
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.

Return to SQL Source Control EAP

Who is online

Users browsing this forum: No registered users and 0 guests