Re: ADO-Error when inserting row with text column with large text

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: Josef Springer <Josef(dot)Springer(at)joops(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: ADO-Error when inserting row with text column with large text
Date: 2013-06-14 15:13:48
Message-ID: 51BB332C.1010502@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

(2013/06/14 23:49), Josef Springer wrote:
> Hi Hiroshi,
>
> thanks for your hint.
> But where to change *MaxLongVarcharSize* ?
> I open the recordset with
> /Open( "select * from table", activeConnection: "Driver={PostgreSQL
> Unicode};Server=localhost;Uid=<uid>;Pwd=<pwd>;Database=<database>" )/

Add ;MaxVarcharSize=xxxxxx to your connection string.
The default is 8190.

> I do not know where to give this option. In an ODBC-Setting, there ist
> the possibility to define *MaxLongVarcharSize*, but i am using the
> driver by gibving its systemname.

regards,
Hiroshi Inoue

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2013-06-14 22:01:09 Re: ADO-Error when inserting row with text column with large text
Previous Message Josef Springer 2013-06-14 14:49:39 Re: ADO-Error when inserting row with text column with large text