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 22:01:09
Message-ID: 51BB92A5.8060305@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

(2013/06/15 0:13), Hiroshi Inoue wrote:
> (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.

Please also try to add
TextAsLongVarchar=1
option to your connection string.

regards,
Hiroshi Inoue

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Josef Springer 2013-06-15 11:55:23 Re: ADO-Error when inserting row with text column with large text
Previous Message Hiroshi Inoue 2013-06-14 15:13:48 Re: ADO-Error when inserting row with text column with large text