Re: ADO-Error when inserting row with text column with large text - Mailing list pgsql-odbc

From Hiroshi Inoue
Subject Re: ADO-Error when inserting row with text column with large text
Date
Msg-id 51BB92A5.8060305@tpf.co.jp
Whole thread Raw
In response to Re: ADO-Error when inserting row with text column with large text  (Hiroshi Inoue <inoue@tpf.co.jp>)
Responses Re: ADO-Error when inserting row with text column with large text  (Josef Springer <Josef.Springer@joops.com>)
List 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



pgsql-odbc by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: ADO-Error when inserting row with text column with large text
Next
From: Josef Springer
Date:
Subject: Re: ADO-Error when inserting row with text column with large text