Thread: [ psqlodbc-Bugs-1010731 ] Incorrect info for varchar(255), text columns
Bugs item #1010731, was opened at 2009-11-18 20:55 You can respond by visiting: http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1010731&group_id=1000125 Category: None Group: None Status: Open Resolution: None Priority: 3 Submitted By: Farid Zidan (faridz) Assigned to: Nobody (None) Summary: Incorrect info for varchar(255), text columns Initial Comment: PostgreSQL ANSI ODBC driver 8.04.01 returns incorrect info for SQLColAttribute SQL_DESC_TYPE and/or SQL_DESC_OCTET_LENGTH Example, create table test_varchar(col1 varchar(20), col2 varchar(255), col3 text); I get the following information from SQLColAttribute: column SQL_DESC_TYPE SQL_DESC_OCTET_LENGTH col1 SQL_VARCHAR 20 col2 SQL_LONGVARCHAR 255 col3 SQL_LONGVARCHAR 8190 col1 info is correct. col2 SQL_DESC_TYPE should be SQL_VARCHAR not SQL_LONGVARCHAR. col3 SQL_DESC_OCTET_LENGTH should be something large such as 2147483647 (2**31 -1) Attached is screenshot of the Firebird vs PostgreSQL ODBC driver results for the test table above (MS SQL Server ODBC driverreturns the same info as the Firebird ODBC driver) ---------------------------------------------------------------------- Comment By: Richard Broersma (rabroersma) Date: 2009-11-18 21:21 Message: I have one thought that might be unrelated to your problem: Notice the ODBC driver setting for Max LongVarChar. http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/~checkout~/psqlodbc/psqlodbc/docs/config.html?rev=1.10&content-type=text/html I wonder if the ODBC driver is masking the actual size that a TEXT column could be? ---------------------------------------------------------------------- You can respond by visiting: http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1010731&group_id=1000125