size of text

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tina - 08 Apr 2004 02:55 GMT

hi folks.
in a text field, is each character/space 1 byte in size? so 7 characters
stored in the field in one record would take up 7 bytes of space? and 20
characters stored in the field in another record would take up 20 bytes of
space?
strange question, maybe. or maybe stupid, but please bear with me. i'm
hoping to learn the actual storage space used, to help me decide whether to
use a text field or byte (number) field in a "many, many records" table.
thx
tina

Reply to this Message

Allen Browne - 08 Apr 2004 03:15 GMT

Tina, there are many factors that influence the answer to your question,
e.g.:

- Access uses space based on the actual number of characters in the field,
not the field's Field Size property.

- If the field's UniCode Compression is not on, it probably uses 2 bytes per
characters.

- There is an overhead for every field, regardless of whether it has any
data.

- Memo fields are different again, with a fixed number of bytes for every
record to store the address, and the actual data in another location.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> hi folks.
> in a text field, is each character/space 1 byte in size? so 7 characters
[quoted text clipped - 6 lines]
> thx
> tina

Reply to this Message

tina - 08 Apr 2004 03:39 GMT

yes, i knew that the Field Size property does not affect the storage space
used for the actual stored data. i'm specifically concerned with the storage
space used per stored character in a text data-type field. reading the Help
for the Unicode Compression property in a table's field never occurred to
me - i could have saved us both some time. :)
the Help seems to be telling me that each stored character will take up *at
least* one byte of space. that's enough info to help me make my decision, i
think.
thanks for responding so quickly, Allen, and pointing me in the right
direction! :)

> Tina, there are many factors that influence the answer to your question,
> e.g.:
[quoted text clipped - 22 lines]
> > thx
> > tina

Reply to this Message