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 |
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 |