Hi Andy, I am not sure what you mean by your application fails but here is some general information about CLOB datatype in Derby. In Derby, CLOB values are limited to a maximum of 2,147,483,647 characters. Derby documentation on various datatypes can be found in Reference Manual at http://db.apache.org/derby/manuals/index.html#docs_10.3
Mamta On 4/14/08, Andy Rozman <[EMAIL PROTECTED]> wrote: > Hi ! > > I am new to derby and I have one question. I am using Hibernate with my > application and I am having little problems with Derby... (I used same db > configutaion on PostgreSQL, Mckoi and HsqlDb)... > > It seems that type text (which should be unlimited varchar) is interpreted > as CLOB(255). I don't know where this happens but my application now > fails... Is this Derby problem or Hibernate? I am using latest of Derby > (10.3.2.1) and Hibernate 3.1. > > Which is longest varchar format in Derby? > > If someone uses Hibernate with Derby I would be thankful for any help... > > Andy >