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.
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 LabReceived on Sat May 29 2010 - 08:17:29 CDT