Re: How to make unique constrant on a column case-INsensitive in Oracle 9
- From: "IANAL_VISTA" <IANAL_Vista@xxxxxxxxxxx>
- Date: Sat, 15 Oct 2005 02:05:15 GMT
"Genna" <gralko@xxxxxxxxx> wrote in
news:1129324111.358555.207850@xxxxxxxxxxxxxxxxxxxxxxxxxxxx:
> I have a task:
> set unique constraint on a table column but I don't care about case
> sensitivity. How to implement it? I know Oracle 10 has NLS_SORT=xxxx_CI
> setting with 'CI' suffix that is 'Case Insensitive' just to address the
> issue. But I need to solve this for Oracle 9.
> Thanks in advance.
> Genna.
>
>
Use either UPPER() or LOWER() functions in the WHERE clause
.
- Follow-Ups:
- References:
- Prev by Date: How to make unique constrant on a column case-INsensitive in Oracle 9
- Next by Date: Oracle 10 G on Linux
- Previous by thread: How to make unique constrant on a column case-INsensitive in Oracle 9
- Next by thread: Re: How to make unique constrant on a column case-INsensitive in Oracle 9
- Index(es):
Relevant Pages
|
|
