Re: Long datatype?

A copy of this was sent to "-=< a q u a b u b b l e >=-" <aquabubble_at_Remove.No.Parma.Ham.Remove.geocities.com> (if that email address didn't require changing) On Mon, 25 Oct 1999 00:02:13 +0100, you wrote:

>Phil <phillipet_at_mobilair.qc.ca> wrote in message
>news:3813141F.33DF3272_at_mobilair.qc.ca...
>>
>> HI,
>>
>> I've a table like this :
>>
>> ID VARCHAR2(20)
>> KeyWord VARCHAR2(100)
>> Narration LONG
>>
>>
>> A LONG Datatype have a 2 Gigs possibilities, yes?
>
>Someone correct me if I'm wrong but I thought it was 64k? And since you are
>trying to fill the last character with one from your assignement it raises
>this error.

64k was the v6.x limit.

2gig is the 7.x limit.

>
>But hang on, wouldn't it raise the 'numeric or value error' if that was the
>case?
>
>I really should learn not to think aloud!
>

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