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" - Unknown