Re: Upper case storage by default???

Hi Michael,

        As a DBA I shudder at the thought of changing any property of the data that is to be stored. I get paid to preserve and protect the data of my employer and our customers and changing the case of data is a violation of the integrity of that data. In most cases this is nitpicking, but I have encountered situations where data is case sensitive and it is necessary to maintain the case in order to meet business requirements. The problem is there is no way to tell in advance that some specific data column will never be case sensitive.

        If you are using 8i I understand that you can use an UPPER or LOWER function on an index. This may not meet your requirement that there be no impact on the applications since they would have to be inspected (and probably) changed.

regards
jerry gitomer

Michael wrote in message ...
>Does anyone know of an INIT parameter or NLS setting(character
set) or any
>method that causes Oracle (8.0.5+) to store information in
uppercase only,
>completely independant of the application interface code.
>Or conversely some reasoning why this can't/shouldn't be
allowed.
>
>Thanks in advance
>
>Michael
>
>
Received on Wed Sep 15 1999 - 12:50:56 CDT