RE: varchar2(4000)

Hi,
I checked the length of the column after inserting a value of more than 4000 characters. Oracle stored only 4000 characters. It probably means that, oracle is truncating the string that falls after 4000 characters and then inserting, without passing a comment on it.

Thanks,
Amar
050-7883254
ts2017_at_emirates.com
amar_padhi_at_hotmail.com

-----Original Message-----
From: Shreepad Vaidya [mailto:Shreepad.Vaidya_at_alltel.com] Sent: Friday, August 18, 2000 10:55 AM
To: Multiple recipients of list ORACLE-L Subject: Re: varchar2(4000)

Hi Rahul/List,

In Oracle 8i manual the definition of Varchar2 is given as

 VARCHAR2(size)
 Variable-length character string having maximum length size bytes. Maximum size is 4000, and minimum is 1. You must specify size for VARCHAR2. I guess it means that max is 4000 bytes, and not characters. I even went further and tried the following insert ..............

insert into test values(rpad
('rahul',9999999999999999999999999999999999999999999

9999999999999999999999999999999999999999999999999999,'x'))

But this is not the max limit........................................

                                   shreepad.

-- 
Author: Shreepad Vaidya
  INET: Shreepad.Vaidya_at_alltel.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).