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 ([EMAIL PROTECTED]) (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
