Data Type Lengths

Sorry about formatting. The information is on edoc Database Design Guide Table 4.2
Code:
[/font]
[font=Courier New]Datatype		Bytes[/font]
[font=Courier New](Value)[/font]
 
[font=Courier New]Character	   1 + number of characters, excluding trailing blanks. If the number of characters is greater than 240, add 3 to the  number of characters instead of 1.

[/font] 
[font=Courier New]Date			3

[/font] 
[font=Courier New]Decimal
zero			1
nonzero		 2 + (number of significant digits + 1)/2 bytes

[/font][font=Courier New]Integer
zero			1
1			   2
128			 3
32768		   4
8  million	  4
2,147,483,647   5
[/font]
 
[font=Courier New]Logical
[/font][font=Courier New]false		   0
true			1[/font]
[font=Courier New]
 
Back
Top