Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 9i and null values
On 9 Jul., 19:05, pound..._at_nyc.rr.com wrote:
> For a VARCHAR2, the length field is variable depending on the size of
> the data. If the length is <= 250, then the length field is one byte.
> For strings > 250 the first byte is 0xFE followed by a two byte length
> field. Nulls are represented by a single byte of 0xFF.
>
> JR
Ok. I know now for varchar2. But how much bytes are uses by a NULL value in a number(p, s) or other fields? Received on Tue Jul 10 2007 - 02:34:41 CDT
![]() |
![]() |