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

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