Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Unicode Character Allocation
> i.e. does VARCHAR2(100 BYTE) equal 400 bytes or 100 bytes of disk
> space allocated? It seems to me that this is the case, from my testing.
> And unfortunately my Oracle DBA was not able to confirm this.
If you specify VARCHAR2(100 BYTE), then this will allocate up to 100 bytes. If you specify VARCHAR2(100 CHAR), then this will let you hold up to 100 characters, which could be up to 400 bytes depending on the number of bytes for each character. The CHAR option is the default so most just use VARCHAR2(100).
HTH,
Brian
-- =================================================================== Brian Peasland oracle_dba_at_nospam.peasland.net http://www.peasland.net Remove the "nospam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three" - UnknownReceived on Thu Apr 13 2006 - 14:45:46 CDT