Re: Riddle me this Oracle riddle...

I believe that varchar2 is a null-terminated string (like in C). Varchar is the string with the byte count at the beginning (like Pascal).

"Jamadagni, Rajendra" wrote:

> Initially is will be nothing unless test.col2 has a default value as
> varchar2 structures are data_length followrd by actual string. The maximum
> that p_in_one can have is 200 bytes thought due to its anchored definition.
>
> The answer, none initially as it will be initializes to NULl value, then
> whatever you assign ti it plus 2 bytes to store the length of the actual
> string, max size is 200+2 bytes (assuming standard characterset).
>
> This has no baring on max size of varchar2 because by definition of
> p_in-one, its max length is limited to 200.
>
> Raj
> ______________________________________________________
> Rajendra Jamadagni MIS, ESPN Inc.
> Rajendra dot Jamadagni at ESPN dot com
> Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
>
> QOTD: Any clod can have facts, but having an opinion is an art!
>
> ------------------------------------------------------------------------
> Name: ESPN_Disclaimer.txt
> ESPN_Disclaimer.txt Type: Plain Text (text/plain)
> Encoding: 7BIT

--
Scott Canaan (srcdco_at_rit.edu)
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put into it" -
Tom Lehrer


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Scott Canaan
  INET: srcdco_at_ritvax.rit.edu

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