MIME-Version: 1.0
From: Igor Korot <ikorot01@gmail.com>
Date: Wed, 10 Aug 2022 00:46:18 -0500
Message-ID: 
 <CA+FnnTx5uc16kSA_D=-wkcT9ZNj3skjxkt70GytyV5MvB6KNjQ@mail.gmail.com>
Subject: what is data type -5?
To: PostgreSQL ODBC list <pgsql-odbc@postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2BFnnTx5uc16kSA_D%3D-wkcT9ZNj3skjxkt70GytyV5MvB6KNjQ%40mail.gmail.com>
Precedence: bulk

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.