VARCHAR, CHAR types changed ?

From: "lothar(dot)behrens(at)lollisoft(dot)de" <lothar(dot)behrens(at)lollisoft(dot)de>
To: pgsql-odbc(at)postgresql(dot)org
Subject: VARCHAR, CHAR types changed ?
Date: 2005-11-25 12:08:47
Message-ID: 1132920527.684951.286500@g43g2000cwa.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi,

I am trying the new, or most actual database under Windows 2000 (8.0).
This driver don't let
my test application crash. Compared to the old driver and Database
(07.03.0200), my
other application should run too.

But I get some unexplainable changes in supported types. My
VARCHAR(100) and even,
if I change it to CHAR(100), isn't any more supported.

(The error message from me reports -8 as DataType)

What has been changed ?

Thanks, Lothar

My detection code for data types looks like this:

switch (DataType) {
case SQL_CHAR:
case SQL_VARCHAR:
case SQL_LONGVARCHAR:
buffer = malloc((ColumnSize+1)*rows);
_DataType = DataType;
bound = 1; // Try a spacer
for bugfix
memset(buffer, 0, (ColumnSize+1)*rows+20);
ret = SQLBindCol(hstmt, column, SQL_C_DEFAULT, buffer,
(ColumnSize+1),
&cbBufferLength);
if (ret != SQL_SUCCESS) query->dbError("SQLBindCol()",
hstmt);
break;
default:
cout << "lbBoundColumn::bindColumn(...) failed: " <<
"Unknown or not supported datatype for column '" <<
columnName << "': " << DataType << endl;
break;
}

Browse pgsql-odbc by date

  From Date Subject
Next Message Dave Page 2005-11-25 12:31:27 Re: VARCHAR, CHAR types changed ?
Previous Message noreply 2005-11-25 10:44:18 [ psqlodbc-Bugs-1000432 ] Inconsistent PGAPI_ declarations