April 18, 2012 at 2:22 pm
Hello,
I'm lost here. I tried to find if it's a known bug with no sucess, so maybe someone here will know what is going on.
In Management Studio 2008 R2 or 2012, when i want to create a new user-Defined Data type based on a int or bigint Data Type, it tell me that the storage will be 9 bytes.
Management studio 2005 show the good storage : 4 bytes.
When i use this data type in a table and i run select DATALENGTH(IntColumn) from table, i get 4 as a result.
I'm guessing its only a display error in Management studio, but i want to be sure.
April 19, 2012 at 10:14 am
To help anyone understand what im talking about, i added a screenshot.
it's in french, but i think you can still understand what is going on !
Storage = Stockage
octets = bytes
To get to that screen you need to manually create a new user defined data type in Management studio.
April 19, 2012 at 2:43 pm
So if anyone open this thread in the futur, it's infact a display bug.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply