what is data type -5?

From: Igor Korot <ikorot01(at)gmail(dot)com>
To: PostgreSQL ODBC list <pgsql-odbc(at)postgresql(dot)org>
Subject: what is data type -5?
Date: 2022-08-10 05:46:18
Message-ID: CA+FnnTx5uc16kSA_D=-wkcT9ZNj3skjxkt70GytyV5MvB6KNjQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi, ALL,

[code}
SQLSMALLINT columnNameLen, columnDataType, colummnDataDigits,
columnDataNullable;
SQLULEN columnDataSize;
/* columnData = new SQLWCHAR *[numCols];
columnDataLen = new SQLLEN [numCols];*/
auto columnName = new SQLWCHAR[50];
memset( columnName, '\0', 50 );
ret = SQLDescribeCol( stmt, 1, columnName, 256,
&columnNameLen, &columnDataType, &columnDataSize, &colummnDataDigits,
&columnDataNullable );
if( ret != SQL_SUCCESS && ret != SQL_SUCCESS_WITH_INFO )
{
GetErrorMessage( errorMsg, 1, stmt );
result = 1;
}
[/code]

After executing the code above the value of columnDataType is -5
and all standard SQL types are positive.

What does -5 correspond to?
Is it the same as 5 which is SQL_SMALLINT, according to sql.h?

Thank you.

Browse pgsql-odbc by date

  From Date Subject
Next Message Jonnalagadda, Ram Reddy (C) 2022-08-19 13:21:39 postgresql 10.03
Previous Message Regina Obe 2022-07-26 05:02:11 RE: Question for psqlodbc_13_02