Postgres Pro
Downloads
Home   >   mailing lists

Re: does the JDBC driver offer a similar property to the ODBC Text As LongVarchar? - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: does the JDBC driver offer a similar property to the ODBC Text As LongVarchar?
Date
Msg-id CADK3HHK2LxQemR6-+ruPBE0p6Wa28MeNf0DWJ34-gY4FHbSHpQ@mail.gmail.com
Whole thread Raw
In response to does the JDBC driver offer a similar property to the ODBC Text As LongVarchar?  (the6campbells <the6campbells@gmail.com>)
List pgsql-jdbc
Tree view
Not that I am aware of, no.

Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca



On Mon, Nov 12, 2012 at 1:00 PM, the6campbells <the6campbells@gmail.com> wrote:
In the Postgres ODBC driver you can confirm Data Type Options:Text as LongVarChar = True and set Max properties for Varchar and LongVarChar.

I did not see if the JDBC driver is providing similar options in the recent 9.x drivers.

As-is, Postgres likes to describe the precision on character expressions as text 2147483647 which may make sense if the business data was to be a CLOB. But an application that is using the precision for other purposes will dislike the value. Hence, with ODBC you could change the way data was described/returned.





pgsql-jdbc by date:

Previous
From: the6campbells
Date:
Subject: does the JDBC driver offer a similar property to the ODBC Text As LongVarchar?
Next
From: Kris Jurka
Date:
Subject: Re: does the JDBC driver offer a similar property to the ODBC Text As LongVarchar?