Varchar2 datatype is NOT null terminated in C or anywhere else that I can
think of. It is a 2 member structure one being the contents the other is
length of contents.
Rick
Scott Canaan
<srcdco@ritva To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
x.rit.edu> cc:
Sent by: Subject: Re: Riddle me this Oracle
riddle...
root@fatcity.
com
03/06/2002
08:58 AM
Please
respond to
ORACLE-L
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
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).
