db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gerhard Otte" <Gerhard.O...@emediapark.de>
Subject AW: CLOB vs BLOB
Date Fri, 27 Aug 2004 06:20:27 GMT
beacause you can not use a blob column in a where clause
of a select statement.

Gerhard Otte
__
mailto:G.Otte@emediapark.de     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:saravkrish@uky.edu]
> Gesendet: Donnerstag, 26. August 2004 20:49
> An: torque-user@db.apache.org
> 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 <torque@seinsche.net>
> To: "Apache Torque Users List" <torque-user@db.apache.org>
> 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: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
> 
> 
Mime
View raw message