[Zope] DCOracle 2 and long text fields..How to use them?
   
    Chris Beaumont
     
    cbeaumon@msri.org
       
    Fri, 3 May 2002 13:49:15 -0800
    
    
  
Hello,
Maybe someone here can help..
I had thought that DCOracle 2 (now) supported long text fields, but 
when I tried to insert more than 2k into one (after upgrading) I got 
a 'string literal too long' error from Oracle.
Is there some trick to this or am I running into a DCO2 or Oracle limitation?
I'm using Oracle 7 which (I think) is supposed to support up to 32k 
in long text fields..
I'd hate to have to continue working around this in the way I have, 
by using Oracle7's 2k(max) varchar2 columns and splitting text in 
Python on input/concatenating them together on output.. That is just 
ugly..
There must be a better way...
Also, is there any way to use the LONG RAW datatype to store images?
We are using Zope with Oracle as a CMS and need the long text 
capability for descriptions within web pages..
BTW...We are a nonprofit and can't afford the upgrade to Oracle 8/9.. etc.
-Chris