Re: Aw: Oracle 12c Case insensitive searches
From: Andy Sayer <andysayer_at_gmail.com>
Date: Tue, 03 Apr 2018 16:02:42 +0000
Message-ID: <CACj1VR7_Wo_V=11brbyuw52GHwzQWddeK95E8r0AEybJtYAs5g_at_mail.gmail.com>
Date: Tue, 03 Apr 2018 16:02:42 +0000
Message-ID: <CACj1VR7_Wo_V=11brbyuw52GHwzQWddeK95E8r0AEybJtYAs5g_at_mail.gmail.com>
If by 12c you mean 12.2, there is now column level collation https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sqlrf/Data-Type-Comparison-Rules.html#GUID-A114F1F4-A08D-4107-B679-323DC7FEA31C
Obviously, there’s a ton of info on Oracle-Base https://oracle-base.com/articles/12c/column-level-collation-and-case-insensitive-database-12cr2
Hope this helps,
Andrew
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Apr 03 2018 - 18:02:42 CEST