Re: varchar

"Bastiaan Schaap" <bschaap_at_desyde.nl> wrote in message news:Y9Zx6.12$t14.752_at_psinet-eu-nl...
> oops... forgot: You want to use this field for a guestbook. I'm an Oracle
> Webdeveloper, and we always use CLOB datatype for this kind of
 information.
> The CLOB can theoretically hold up to 2GB of data,

CLOBs actually support up to 4Gb of data.

You are thinking of the Oracle 7 LONGs.

Regards
HJR so that should be more
> than enough to fit you needs... In order to display this field, you kan
> parse through the column by using dbms_lob functionality. A simple loop
 with
> dbms_lob.read should suffice... I don't know if you're using an OAS or
 PHP.
> If you work with PHP I should stick with the varchar2, or make a simple
> stored procedure that you execute in your script at the place where the
 data
> has to be...
>
> Hope this helps,
>
> --
> Bastiaan Schaap
> Desyde BV
> bschaap_at_desyde.nl
> Tel 06 - 51998277
> Fax 035 - 5430547
> http://www.desyde.nl
> ________________________________
>
> "Ever stop to think, and forget to start again?"
>
> "Bastiaan Schaap" <bschaap_at_desyde.nl> wrote in message
> news:O4Zx6.10$t14.783_at_psinet-eu-nl...
> > You can use a varchar2... A varchar2 can contain 32767 characters if you
> > define it within PL/SQL, or 4000 characters if it is a column-type (for
> > Oracle 8!). I'm not sure about Oracle 7, but I think it's the same
> > numbers...
> >
> >
> > Hope this helps,
> >
> > --
> > Bastiaan Schaap
> > Desyde BV
> > bschaap_at_desyde.nl
> > Tel 06 - 51998277
> > Fax 035 - 5430547
> > http://www.desyde.nl
> > ________________________________
> >
> > "The first rule of politics is Never Believe Anything Until It's Been
> > Officially Denied."
> >
> > "las" <laasunde_at_online.no> wrote in message
> > news:00Zx6.3011$R6.62751_at_news1.oke.nextra.no...
> > > varchar can contain 255 characters, right ? I need something thats
 bigger,
> > > what are my options ? Looking to make a guestbook for my a web site
 and
 255
> > > is to few letters I reckon...
> > >
> > > las
> > >
> > >
> >
> >
>
>
Received on Wed Apr 04 2001 - 06:12:39 CDT