Re: [cx-oracle-users] type object matching - BINARY

[Mario F. <mf...@zo...>]

On 2006-0913 08:09:50, Anthony Tuininga wrote:
> To answer your question: Oracle has three types that hold binary
> data -- RAW, LONG RAW and BLOB. They are all quite different
> [...]  Please feel free to educate me if necessary. :-)

I'm a very bad educator! :)  I hope I will manage to explain myself
at least.

let's start from the problem I'm trying to solve...  I need to perform a
SELECT DISTINCT <fields> FROM ... and I don't want to make any
assumptions about the table...  I know that the table may contain LOBs
and on them Oracle complains that it cannot perform a comparison.  to be
safe, I want to filter out all ''BINARY'' fields, in the sense, all
those fields where comparison is not possible or would take too long a
time...  as stated in the PEP249:

BINARY
   This type object is used to describe (long) binary columns
   in a database (e.g. LONG, RAW, BLOBs).

this 'BINARY' is not a type, but a type object, something quite abstract
that is used to cathegorize the concrete types in the database into
db-api2 concepts.  back to my question, at the very least 
cx_Oracle.BINARY == cx_Oracle.BLOB
should check True...  my interpretation is that also LOBs and CLOBs are
cathegorized as BINARY...  but this is my interpretation...

thanks for your time,
Mario

-- 
... hinc sequitur, unamquamque rem naturalem tantum iuris ex natura habere,
    quantum potentiae habet ad existendum et operandum ...
  -- Baruch de Spinoza, TRACTATUS POLITICUS