| Re: [stellation-res] Oracle backend! |
On Wed, Jul 24, 2002 at 09:31:38AM -0400, Mark C. Chu-Carroll wrote: > On Wednesday 24 July 2002 05:48 am, Ringo De Smet wrote: > > Hello, > > > > Based on Mark's explanation that is also copied to the Eclipse Wiki, I > > started writing an Oracle backend. I'm now at the point where I have > > been able to run the command > > > > svc --location=oracle:svc configure database > > > > successfully. There are some remarks however: > > > > 1) For the long string, I have used Oracle's VARCHAR(2000). If my > > colleague has informed me well, this seems to be the largest size > > possible. In the DB2 version, it was put on 16000, so I will have to > > look into this further. > > They really don't support a varchar longer that 2K? Yes, they do. It's called VARCHAR2. From [1] "The VARCHAR2 datatype takes a required parameter that specifies a maximum size up to 32767 bytes." I have never user VARCHAR with Oracle ;) Cheers, florin 1. http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/appdev.920/a96624/03_types.htm#10805 -- "If it's not broken, let's fix it till it is." 41A9 2BDE 8E11 F1C5 87A6 03EE 34B3 E075 3B90 DFE4
Attachment:
pgpKfNWKrxEoT.pgp
Description: PGP signature