Re: Oracle 11 Server and Unicode UTF-8

From: Serge Rielau <>
Date: Sat, 29 May 2010 09:17:29 -0400
Message-ID: <>

VARCHAR2(4000) just means that whoever defined the DB schema was too lazy to investigate the domain.
If run a few MAX(LENGTH(..) that will giv eyou a pretty good idea as to what the domain really is.
In all my engagements I have yet to come across a situation where there actually was a requirement for 4000 bytes.

Chances are the vast majority of these are monsters under the bed. So grab a flashlight. :-)


Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto Lab
Received on Sat May 29 2010 - 08:17:29 CDT

Original text of this message