You are viewing a plain text version of this content. The canonical link for it is here.

Posted to slide-user@jakarta.apache.org by Remy Maucherat <re...@apache.org> on 2001/07/06 06:51:42 UTC

JDBC types

> hi remy,
>     The table definition for the property table in the database defines
both
> the property name and the value column types to be a blob. But column type
> blob is not searchable which means that the column cannot be included in
the
> where clause of the SQL statement.What was the need to make both property
> and the value to be a blob.Can this be changed to varchar ?

It depends on your database. Some have really nasty limitations on the
length, which can be a problem :(

Remy