Re: varchar2(4000)

From: Shreepad Vaidya <Shreepad.Vaidya_at_alltel.com>
Date: Fri, 18 Aug 2000 4:09 -0500
Message-Id: <10593.114940@fatcity.com>

Hi Rahul/list,

Oh!!!!!! I do agree to that.

I have found something else in ORacle 8i and also on Oracle 7.3.4.

In my earlier mail i menioned that............ i tried the following
insert (in Oracle 8i and also on Oracle 7.3.4)
Oracle 8i :------------> varchar2.........-> 4000

Oracle 7.3.4:---------> varchar2.........->2000

insert into test values(rpad

('rahul',9999999999999999999999999999999999999999999
9999999999999999999999999999999999999999999999999999,'x'))

The above insert was successful in both 7.3.4 and 8i . But when i queried.............

SQL> select length(col1) from test;

LENGTH(COL1)                       (Oracle 7.3.4)


------------

        2000

SQL> select length(col1) from test;

LENGTH(COL1)                       (Oracle 8i)


------------

        4000

It seems to me that Oracle truncates the data to the max limit.............but does not give an error as it is suppossed to give one.

P.S :----- I prefer Shreepad/Shree...............................Only

my personal feelings/views..... Received on Fri Aug 18 2000 - 04:09:31 CDT