Re: Urgent: Need info on LONG var char

A copy of this was sent to msk914_at_yahoo.com (if that email address didn't require changing) On Thu, 10 Feb 2000 22:29:03 GMT, you wrote:

>Hi.
>
>We are porting our application into Oracle for a customer
>and we are required to have some fields in our tables longer
>than 2048 bytes.
>
>What can we do? What is the syntax for making var char's
>longer than 2048? (This is a snap in access or sql-server,
>we could not believe that we cannot find how in Oracle)
>
>thanks in advance,
>
>Mark
>

In Oracle7.x, the varchar type is limited to 2000 characters. In Oracle8.x, the varchar type is limited to 4000 characters.

In both releases, there is a LONG type which is limited to 2gig.

In Oracle8.x, there is a CLOB type (much better then long) limited to 4gig.

>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Feb 10 2000 - 18:42:08 CST