MDS 2012, assign ~NULL~ to a column of only 2 characters - by Todd C

Status : 


Sign in
to vote
ID 786120 Comments
Status Closed Workarounds
Type Bug Repros 1
Opened 5/2/2013 9:00:25 AM
Access Restriction Public


MDS 2008 R2 had no concept of a NULL value. They were actually empty strings.
SQL 2012 MDS allows null, and to ASSIGN a NULL value to an attribute, you actually pass in the value of " ~NULL~ ". This is from Microsoft's own documentation.

But what if the column/attribute you are trying to assign the NULL value is only 2 characters?
Result: ERROR
Sign in to post a comment.
Posted by Microsoft on 6/25/2013 at 10:41 AM
Hello Todd. We’ve looked into this item. While it will not be addressed in the current release cycle, we have added it to a list for consideration for the next. Thank you for the feedback. We will keep track of the suggestion. In the meantime, we hope that difining you state ID or other variables as three characters. This will consume a few extra bits of drive space, but should unblock you until we can work this into a future release.

-Walter A Jokiel, Program Manager, SQL Server (