Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: varchar

Re: varchar

From: Bastiaan Schaap <bschaap_at_desyde.nl>
Date: Mon, 2 Apr 2001 13:12:58 +0200
Message-ID: <O4Zx6.10$t14.783@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 Mon Apr 02 2001 - 06:12:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US