- SQLColAttribute calls into SQLColAttribute calls in ODBC Driver for Teradata
- Output parameters from UTF-8 back to the application code page
As a result, the output parameters from SQLColAttribute are returned to the ANSI application in the internal character set used by the driver. If the internal character set is different from the application code page, the application receives data back from SQLColAttribute in a different character set from what was expected.
This is a problem if, for example, an ANSI application using ISO 8859-1 requests non-ASCII metadata (such as a column name with Danish characters) and the session character set is UTF-8. The application gets the column name back in UTF-8. In general, if an ANSI application uses a Unicode session character set, it gets data back from SQLColAttribute in UTF-8, regardless of the application code page.
To avoid this problem, use the old SQLColAttributes function (with an 's' at the end).