Re: text type handling

On Tue, 2 Dec 2008, Ken Boss wrote:

> ... that postgres text datatypes appear to Crystal as String fields of 
> length -1, which confuses the software and prohibits their use.  This is 
> particularly problematic given postgresql's proclivity for casting the 
> results of concatenations, unions, etc. to text on-the-fly.
>
> I see a long thread related to this topic from about a year ago here: 
> http://archives.postgresql.org/pgsql-jdbc/2007-12/msg00145.php , but it 
> seems to have run its course without coming to any specific conclusions.

The conclusion that Oliver and I seemed to come to was that the type 
returned should not be changed, but instead the precision should be 
changed from -1 to Integer.MAX_VALUE.  This change hasn't been made yet, 
but that will happen before the 8.4 release.  This change won't be 
backpatched to earlier driver releases for backwards compatibility 
reasons.

Kris Jurka