Re: Oracle 11 Server and Unicode UTF-8

From: Serge Rielau <srielau_at_ca.ibm.com>
Date: Sat, 29 May 2010 09:17:29 -0400
Message-ID: <86cifaFs7oU1_at_mid.individual.net>



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. :-)

Cheers
Serge

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