Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 9i and null values

Re: Oracle 9i and null values

From: <poundboy_at_nyc.rr.com>
Date: Mon, 09 Jul 2007 10:05:13 -0700
Message-ID: <1184000713.697128.64370@o61g2000hsh.googlegroups.com> 





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
Received on Mon Jul 09 2007 - 12:05:13 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US