[AccessD] Translation data length (cache used)

Stuart,

Thanks for that.

John W. Colby
www.ColbyConsulting.com


Stuart McLachlan wrote:
>>From Access 2003 - VBA Help:
> 
> Data Type Summary
> String 
> (variable-length) 10 bytes + string length 0 to approximately 2 billion  
> 
> and 
> 
> Differences in String Function Operations
> The memory storage formats for text differ between Visual Basic for Applications (VBA) 
> code and Access Basic code. (Access Basic was used in early versions of Microsoft 
> Access.) Text is stored in ANSI format within Access Basic code and in Unicode format in 
> Visual Basic.  
> 
> The Unicode format is used in Visual Basic to match the format of text within OLE, which is 
> indirectly related to Visual Basic.  
> ...snip...
> Storage format Storage pattern Description 
> Unicode 41 00 42 00 43 00 42 30 44 30 46 30 Each character is stored as 2 bytes. 
> ANSI 41 42 43 82 A0 82 A2 82 A4 ASCII characters are stored as 1 byte; double-byte 
> characters are stored as 2 bytes. 
>