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

Hello Hiroshi,

much thanks to you !!!!!!!
Adding MaxLongVarcharSize=<nnn> and TextAsLongVarchar=1 to the connection string works perfect !

mit freundlichen Grüßen / best regards,
Josef Springer
(Geschäftsleitung/Management)

	Address	Josef.Springer@joops.com	Orlando-di-Lasso Str. 2	D-85640 Putzbrunn
	Office	+49 (0)89 600 6920
	Fax	+49 (0)89 600 69220
	Web	http://www.joops.com

(HRB München 86239) -- the software company --

On 15.06.2013 00:01, Hiroshi Inoue wrote:

(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