Re: Large text-datatype

From: Clemens Hoffmann <choffmann_at_heeg.de>
Date: Fri, 16 Feb 2001 09:42:44 +0100
Message-ID: <96ip60$2mi$1@charly.heeg.de>

"Jim Kennedy" <kennedy-family_at_home.com> schrieb im Newsbeitrag news:eFvi6.424764$U46.12393150_at_news1.sttls1.wa.home.com...
> 4,000 is thousands :-)
> Look at Clob - limit is 4 gigs.
> Jim

Be aware that you cannot query CLOBs unless you use the Oracle context option to craete a fulltext index on yout text data.

> "John Doe" <johndoe_at_smartweb.com> wrote in message
> news:96dvk9$8ac$1_at_oslo-nntp.eunet.no...
> > I miss a datatype for text that can store thousands of characters.
Varchar2
> > only stores 4000 letters. Does anyone know how to solve this?
Received on Fri Feb 16 2001 - 02:42:44 CST