beacause you can not use a blob column in a where clause of a select statement.
Gerhard Otte __ mailto:[EMAIL PROTECTED] emediapark GmbH http://www.emediapark.de Tel:+49 (0)941 630804-2 Fax:-9 Hemauerstr.14,93047 Regensburg,Germany > -----UrsprÃngliche Nachricht----- > Von: Saravana Krishnan Kannan [mailto:[EMAIL PROTECTED] > Gesendet: Donnerstag, 26. August 2004 20:49 > An: [EMAIL PROTECTED] > Betreff: CLOB vs BLOB > > > Hi, > > This might be a bit off Topic but here goes... > > I don't see the need for a CLOB type in a Database (to be > more specific - Oracle) when there is support for a BLOB > type. Any CLOB can be stored as a BLOB, so what is the need > for a CLOB? I agree that any other type too can be stored in > a BLOB, but I also understant they have other features that > are not present in a BLOB and they are faster than a BLOB > (BLOB is a pointer, but primitive types are directly stored). > Thus it makes sense having primitive data types. > > I don't see any feature in a CLOB that is not present in a > BLOB. Obviously I'm missing something - can someone point out > what I'm missing? > > Thanks, > Sarav > > > -----Original Message----- > From: Axel Seinsche <[EMAIL PROTECTED]> > To: "Apache Torque Users List" <[EMAIL PROTECTED]> > Date: Thu, 26 Aug 2004 17:21:42 +0200 (CEST) > Subject: setting sequence start value in schema-xml file > > Hi all, > > is it possible to set a start value (and increment step) in > the schema xml file? I didn't find anything when looking > through the DTD for the id-method-parameter tag. But maybe > someone already did that and can give me a short hint. > > Thank you. > > Axel > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
