From: Andreas Thiele
Subject: CLSQL and Oracle Blob Types?
Date: Sat, 12 Jan 2008 14:39:16 +0000
Message-ID: <fmajen$tq1$03$1@news.t-online.com>

Hi,

can anybody tell wether I am correct: CLSQL does not support any Blob type with the Oracle Backend?

Andreas

From: Edi Weitz
Subject: Re: CLSQL and Oracle Blob Types?
Date: Sat, 12 Jan 2008 16:00:02 +0000
Message-ID: <uwsqfyqyl.fsf@agharta.de>

On Sat, 12 Jan 2008 15:39:16 +0100, "Andreas Thiele" <······@nospam.com> wrote:

> can anybody tell wether I am correct: CLSQL does not support any
> Blob type with the Oracle Backend?

There's no specific support for Oracle BLOB types, but you can read
and write CLOB columns like VARCHAR columns if you obey the 4000
characters limit imposed by OCI.  It is relatively easy to write code
that does this transparently (you fiddle a bit with || and SUBSTR and
so on), but of course it's probably not what you want if you're
concerned about performance.

Edi.

-- 

European Common Lisp Meeting, Amsterdam, April 19/20, 2008

  http://weitz.de/eclm2008/

Real email: (replace (subseq ·········@agharta.de" 5) "edi")