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

Hello Hiroshi,<br /><br /> much thanks to you !!!!!!!<br /> Adding <i>MaxLongVarcharSize=<nnn> </i>and
<i>TextAsLongVarchar=1</i>to the connection string works perfect !<br /><p>mit freundlichen Grüßen / best regards,<br
/>Josef Springer<br /> (Geschäftsleitung/Management)<table border="0" cellpadding="0" cellspacing="0"
width="75%"><tbody><tr><td><imgalt="Postal" height="16" src="cid:part1.03080603.09050509@joops.com" vspace="2"
width="17"/><br /></td><td valign="top"><font color="#cc0000">Address</font><br /></td><td valign="top"><font
color="#000099"><u><aclass="moz-txt-link-abbreviated"
href="mailto:Josef.Springer@joops.com">Josef.Springer@joops.com</a></u></font><fontcolor="#cc0000"><br
/></font></td><tdnowrap valign="top">Orlando-di-Lasso Str. 2<br /></td><td nowrap valign="top">D-85640 Putzbrunn<br
/></td></tr><tr><tdnowrap valign="top"><img alt="Phone" height="15" src="cid:part2.09010006.04050409@joops.com"
vspace="2"width="13" /><br /></td><td nowrap valign="top"><font color="#cc0000">Office</font><font color="#000099"><br
/></font></td><tdnowrap valign="top"><font color="#000099">+49 (0)89 600 6920</font><br /></td><td nowrap
valign="top"><br/></td><td valign="top"><br /></td></tr><tr><td valign="top"><img alt="Phone" height="15"
src="cid:part2.09010006.04050409@joops.com"vspace="2" width="13" /></td><td valign="top"><font
color="#cc0000">Fax</font><fontcolor="#000099"><br /></font></td><td valign="top"><font color="#000099">+49 (0)89 600
69220</font><br/></td><td valign="top"><br /></td><td valign="top"><br /></td></tr><tr><td valign="top"><img alt="Web"
height="15"src="cid:part4.02070602.08070302@joops.com" vspace="2" width="15" /><br /></td><td valign="top"><font
color="#cc0000">Web</font><fontcolor="#000099"><br /></font></td><td valign="top"><font color="#000099"><a
class="moz-txt-link-freetext"href="http://www.joops.com">http://www.joops.com</a></font><br /></td><td valign="top"><br
/></td><tdvalign="top"><br /></td></tr></tbody></table><table border="0" cellpadding="0" cellspacing="0"
width="50%"><tbody><tr><tdvalign="top"><img align="left" alt="JOOPS" height="61" hspace="0"
src="cid:part5.08000601.09060802@joops.com"width="220" /><br /></td><td nowrap valign="bottom">(HRB München 86239)<br
/><br/><b>-- the software company --</b></td></tr></tbody></table><br /> On 15.06.2013 00:01, Hiroshi Inoue wrote:
<blockquotecite="mid:51BB92A5.8060305@tpf.co.jp" type="cite">(2013/06/15 0:13), Hiroshi Inoue wrote: <br /><blockquote
type="cite">(2013/06/1423:49), Josef Springer wrote: <br /><blockquote type="cite">Hi Hiroshi, <br /><br /> thanks for
yourhint. <br /> But where to change *MaxLongVarcharSize* ? <br /> I open the recordset with <br /> /Open( "select *
fromtable", activeConnection: "Driver={PostgreSQL <br />
Unicode};Server=localhost;Uid=<uid>;Pwd=<pwd>;Database=<database>")/ <br /></blockquote><br /> Add 
;MaxVarcharSize=xxxxxx to your connection string. <br /> The default is 8190. <br /></blockquote><br /> Please also try
toadd <br />   TextAsLongVarchar=1 <br /> option to your connection string. <br /><br /> regards, <br /> Hiroshi Inoue
<br/><br /><br /><br /></blockquote><br /><div class="moz-signature"><br /></div>