Posted by Stefan Schmiedl on Feb 24, 2004; 8:17am
URL: https://forum.world.st/VARCHAR-field-lengths-in-Access-database-tp3369819p3369820.html

On Mon, 23 Feb 2004 19:15:04 -0500,
Bill Schwab <[hidden email]> wrote:
> Hello all,
>
> When analyzing an Access 97 database, #describeCols: is giving me DBColAttr
> instances that (perhaps only by coincidence) answer twice the expected value
> for #length, with #precision containing the length of the field.  Any ideas?

This smells like Unicode to me.
2*n bytes of storage for n characters.

Can you take a peek at the raw contents of such a field?

s.
--
Stefan Schmiedl
Approximity GmbH                                      http://www.approximity.com
Research & Development                             mailto:[hidden email]