public inbox for [email protected]  

help / color / mirror / Atom feed

From: Igor Korot <[email protected]>
To: PostgreSQL ODBC list <[email protected]>
Subject: what is data type -5?
Date: Wed, 10 Aug 2022 00:46:18 -0500
Message-ID: <CA+FnnTx5uc16kSA_D=-wkcT9ZNj3skjxkt70GytyV5MvB6KNjQ@mail.gmail.com> (raw)

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.

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: what is data type -5?
  In-Reply-To: <CA+FnnTx5uc16kSA_D=-wkcT9ZNj3skjxkt70GytyV5MvB6KNjQ@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox