[AccessD] Translation data length (cache used)

I read somewhere long ago that VBA stored strings as 4 bytes that were a length, the data, and a 
trailing Null.

That would be a 5 byte overhead.  Nowhere did it discuss unicode, though this was before the days 
when unicode was so popular.

Can you point me to an explanation of what you are saying?  I Googled trying to find any such 
definition and failed.

John W. Colby
www.ColbyConsulting.com


Stuart McLachlan wrote:
> Len() measures in characters.
> 
> Access stores string data as a 10 byte header, followed by the character data in Unicode, 
> using 2 bytes per character 
> 
> So 2500 strings with a total length of 140,000 character will take
>  (2,500*10) + (140,000*2) = 305,000 bytes.
>   
>