Re: Bug in 7.4_213 driver: returns VARCHAR instead of

[Kris Jurka <books(at)ejurka(dot)com>]

On Thu, 29 Jul 2004, Kris Jurka wrote:

> On Tue, 27 Jul 2004, j.random.programmer wrote:
> 
> > The JDBC version 7.4_213 driver has the following bug
> > 
> > For database SQL type:
> > text	(that is variable unlimited length)
> > 
> > The JDBC driver returns "java.sql.VARCHAR" as
> > the column type. (via database meta data).
> > 
> > This is wrong. The JDBC driver SHOULD return
> > java.sql.LONGVARCHAR (since the text type is
> > of unlimited length).
> > 
> 
> I'm not sure this is clearly wrong, but you do make a convincing argument.

I'm not so sure anymore.  While text can be used for storing large values
it often isn't.  Further returning LONGVARCHAR could be a sign for the
caller to use something like ResultSet.getCharacterStream instead of a
simple getString.

Kris Jurka