Return Max CHAR/VARCHAR Length As 32k

Use32kMaxCharColumnSize

Key Name	Default Value	Required
Use32kMaxCharColumnSize	Clear (0)0	No

Description

This option specifies whether the connector returns a hard-coded value for the COLUMN_SIZE column when you call SQLGetTypeInfo for SQL_CHAR and SQL_VARCHAR data. Enabling this option prevents the returned column size from causing numeric overflows in Microsoft Access.

• Enabled (1)1: The connector returns a hard-coded value for the maximum size of SQL_CHAR and SQL_VARCHAR columns.
• Disabled (0)0: The connector returns the actual maximum size of the column. In some cases, Microsoft Access might experience numeric overflow when processing the column size returned by the connector.

Depending on the Session Character Set (or CharacterSet) setting, the hard-coded value is 32000 or 64000. For more information, see Session Character Set.

Related topics

• Session Character Set
• Advanced Driver Configuration Options on page 1
• Configuring Advanced Options
• Creating a Data Source Name
• Configuring a DSN-less Connection
• Using a Connection String