• 0

# Field Type Size Comparisons

Go to solution Solved by Jan,

## Question

Hello All;

I am working through optimizing my app and step one is to ensure I'm using the proper field types.

Is there an article that describes how much data is used per record per field type?

Specifically:

• General Number
• Integer Number
• Currency Number
• Yes/No
• Text(255)
• Text(64000)

I have a pretty good guess on how these rank, but more detailed information on exact data used will help greatly.

Thanks

## Recommended Posts

• 0

Hello EIQ,

There is the article about data types.

Is it what you are looking for?

Or do you want to know which DataBases data types are used for the corresponding types?

##### Share on other sites
• 0

Something like;

General Number = 16 bytes per record

Integer = 8 bytes per record

Currency = 12 bytes per record

Text (255) = 1 byte per 4 character OR 128 bytes per record

etc.

##### Share on other sites
• 0
• Solution

I tried define types using maximal values.

General Number - allows 15 digits, probably, type is float = 8 bytes per record

Integer Number - from -2147483648 to 2147483647, probably, type is int = 4 bytes per record

Currency Number  - from -922337203685477.5808 to 922337203685477.5807, probably, type is money =  8 bytes per record

Yes/No - probably, 1 byte per record

Text(255) and Text(64000) - as far as I know, if you can use Unicode, it is probably ntext for Text64000 and probably nvarchar for Text255 (because with long string the size of a table growth faster) - so, I think, storage size, in bytes, is two times the string length that is entered for both types.

## Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

×   Pasted as rich text.   Paste as plain text instead

Only 75 emoji are allowed.

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.