Text arrays fails with MaxVarCharSize > 16383

From: Åsmund Kveim Lie <akl(at)nosyko(dot)no>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Text arrays fails with MaxVarCharSize > 16383
Date: 2006-03-23 15:51:09
Message-ID: 4422C3ED.7020800@nosyko.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi all,

I have encountered a strange problem when using text arrays and setting
MaxVarCharSize > 16383 (or -4). The data does not get received through
the ODBC and the log shows a strange error. It appears that it tries to
convert the array to an SQL_C_BINARY (log attached).

To recreate the problem I created a small test table:
CREATE TABLE test (c text[]);
INSERT INTO test(c) VALUES ('{"Hello world"}');

And through my (Windows) app I selected * from test. When having
MaxVarCharSize <= 16383 it works and I get ‘{“Hello world”}’ back, but
setting it to –4 (unlimited length) or > 16383 I get an empty string and
an error in the log.

I’m using PostgreSQL 8.1.3 and ODBC 08.01.0200.

Best regards,

Åsmund Kveim Lie

Attachment Content-Type Size
psqlodbc_1752.log text/plain 3.1 KB

Browse pgsql-odbc by date

  From Date Subject
Next Message Åsmund Kveim Lie 2006-03-23 16:03:06 MaxLongVarChar and new lines in text
Previous Message Lothar Behrens 2006-03-23 10:05:52 Re: Compiling psqlodbc REL-07_03_ENHANCED and 07.03.260