Re: VARCHAR2 greater than 4K?

"Anurag Varma" <avdbi_at_hotmail.com> wrote i

> Max length for a varchar2 column is 4000 bytes.

Wee correction. The max _SIZE_ is 4000 bytes. The length is 4000 only if you use a single byte charset. This seems to bite some people in the butt when they automatically assume that they can stuff a 4000 char block into a VARCHAR2.

FOR SALE:
Oracle/SQL developers.
Basic SQL knowledge. No ears. Slightly abused. Great at making interesting and challenging FURBARs for DBAs to fix. Elevate your DBA skills NOW by having your own FUBAR creating developer. SPECIAL: Buy 2 and get 1 free!!*+

--
Billy

*+ Disclaimer : brains may not be not included