Re: varchar

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, 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

> >

> >

>

>