| Re: [stellation-res] Oracle backend! |
On Wed, Jul 24, 2002 at 02:53:07PM +0100, Ringo De Smet wrote: > --- Florin Iucha <florin@xxxxxxxxx> wrote: > > 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: > > > > 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 ;) > > Did I specify VARCHAR? Than it's just a typo in my mail. In my code > (see patch), I specified VARCHAR2(16000), but this failed on Oracle 8i. > > > 1. > > > http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/appdev.920/a96624/03_types.htm#10805 > > This is a URL for Oracle 9i. Has the VARCHAR2 size changed between 8i > and 9i? Indeed it changed: from [2] Variable-length character string having maximum length size bytes. Maximum size is 4000, and minimum is 1. You must specify size for a VARCHAR2. So get 9i... florin 2. http://technet.oracle.com/doc/server.804/a58225/ch2.htm#27982 -- "If it's not broken, let's fix it till it is." 41A9 2BDE 8E11 F1C5 87A6 03EE 34B3 E075 3B90 DFE4
Attachment:
pgpS018b9yxRM.pgp
Description: PGP signature