Article ID: 236871 - View products that this article applies to.
This article was previously published under Q236871
This article has been archived. It is offered "as is" and will no longer be updated.
When SQLColumns is called on a table in an Access database, the BUFFER_LENGTH and CHAR_OCTET_LENGTH values that appear to be returned are incorrect for non-UNICODE text fields. Fields of data type CHAR and VARCHAR will show these lengths as twice the value of COLUMN_SIZE. This is because Jet now stores text data in the Unicode format, which requires two bytes for every character.
Steps to Reproduce Behavior
Perform the following steps in the ODBC Test utility:
See the documentation for SQLColumns for more information on the data that this function returns.
The ODBC Test utility can be obtained from the Microsoft Data Access SDK, which comes with Visual Studio or can be downloaded from the following Web site:
Article ID: 236871 - Last Review: February 28, 2014 - Revision: 2.1
Contact us for more help
Connect with Answer Desk for expert help.