Hello Kris, hello Oliver,<br /><br /> Kris Jurka schrieb:<br /><blockquote
cite="mid:Pine.BSO.4.64.0712200547450.15638@leary.csoft.net"type="cite"><blockquote type="cite">My main concern is that
'text'is a very common type to use in PostgreSQL based designs, and that JDBC applications are more likely to
understandhow to interpret a field that claims to be VARCHAR than one that is LONGVARCHAR, given that LONGVARCHAR is a
relativelystrange type and at best poorly defined. <br /></blockquote> This is my concern as well, which is why I
suggestedthat changing the precision value might be a better solution. Daniel, any opinion on that alternative? <br
/></blockquote>I thought about this, too. In this case we deliver a VARCHAR(1073741824) for every "text". I think about
thisas being very strange alternative to just saying LONGVARCHAR. Also because of my argument of better using
getStream()for big text fields IS a good alternative. <br /><br /> Okey, how if we give this as an connection parameter
tothe driver? describeUnboundTextAs=VARCHAR(1073741824) (default, current behaviour) vs. showTextAs=LONGVARCHAR. This
shouldbe extended to show postgres varchar(unbound) in the same type. <br /><br /> IMHO should LONGVARCHAR be the
default.If the sql/jdbc spec leaves it relatively undefined, the application (which is generic jdbc and could also use
otherdbs at the backend), should handle those as relatively undefined, too. And IF the application knows about postgres
atthe backend, then there is no problem with LONGVARCHAR in the description, too.<br /><br /> Best regards,<br />
DanielMigowski<br /><br /><br /><div class="moz-signature">-- <br /><pre> |¯¯|¯¯| <b>IKOffice GmbH
DanielMigowski</b>| | |/| Mail: <a
href="mailto:dmigowski@ikoffice.de">dmigowski@ikoffice.de</a>| | // | Nordstr. 10 Tel.: +49 (441) 21 98
8952| | \\ | 26135 Oldenburg Fax.: +49 (441) 21 98 89 55|__|__|\| <a
href="http://www.ikoffice.de">http://www.ikoffice.de</a> Mob.: +49 (176) 22 31 20 76 Geschäftsführer: Ingo
Kuhlmann,Daniel Migowski Amtsgericht Oldenburg, HRB 201467 Steuernummer: 64/211/01864</pre></div>