Postgres Pro
Downloads
Home   >   mailing lists

Re: DataType bytea Precision returning a negative value - Mailing list pgsql-odbc

From Dave Cramer
Subject Re: DataType bytea Precision returning a negative value
Date
Msg-id CADK3HHKM-LMdHVC6dZFoRjsLo3CpXv3V-d_a_pr++BWQhVvvwA@mail.gmail.com
Whole thread Raw
In response to DataType bytea Precision returning a negative value  (Abhishek Kumar <abhishek.aak0@gmail.com>)
List pgsql-odbc
Tree view


On Thu, 11 Jul 2024 at 04:56, Abhishek Kumar <abhishek.aak0@gmail.com> wrote:
Hi,

When we query the psqlodbc driver to get the column information of the table(via SQLColumns), we get a precision value of -4 for bytea column. Is this expected to happen? If yes, what does this value mean for a bytea column. If no, then what is the correct expected behavior?

Looks like we return 
switch (handle_unknown_size_as)
{
case UNKNOWNS_AS_DONTKNOW:
return SQL_NO_TOTAL;
}

Because we don't know the length.

Dave

pgsql-odbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Query regarding Bind data type, precision, scale while using psqlodbc
Next
From: Chang Lu
Date:
Subject: [bug-report]SQLRowCount set affected row numbers is incorrect when use SQLBindParameter and SQLSetStmtAttr for SQL_ATTR_PARAMSET_SIZE