Size Used for Decimal Field. 1

[grnzbra]

If I have some fields for US addresses (ie. state abbreviations are always 2 characters) and set the State field as CHAR(10), each record has 8 wasted characters in the State field. If, however, the State field is set as VARCHAR(10), only the 2 necessary characters will be used and there will not be 8 wasted characters in each record. (Yes, I know that the State field should be set at CHAR(2). This is just setting up for my question.)

If I have a decimal field set for (10,2) but most of the time have 3 or 4 digit integers going into it, does it behave like a CHAR field and waste the extra space, or does it behave like a VARCHAR and use only the space necessary?

 

[imex]

The number of digits in storage depends on the maximum number of decimal digits of the column, as shown in the page below:
[URL unfurl="true"]http://technet.microsoft.com/en-us/library/ms187746.aspx[/url]

Hope this helps.

[URL unfurl="true"]http://www.imoveisemexposicao.com.br/imobiliarias-em-guarulhos[/url]

 

[grnzbra]

Thank you.