[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
|
Re: [stellation-res] Oracle backend!
|
--- 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?
Ringo
__________________________________________________
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
