Re: 9i: Check- constraint Upper(Column)

Carlos schrieb am 02.04.2008 in 
<221a3638-5b82-4086-b097-8e06e50bdccf@[EMAIL PROTECTED]
>:

> Not sure about what you're trying to do, but a Function Based Unique
> Index on (trim(upper(column))) may do the trick...
I try to ensure, that it is impossible to insert/update records in the 
way, that after this there are two records, that differ only by 
BIG/little - Letters and the number of spaces

example:

CMyColumn
----------
TeSt EnTrY

It should be impossible to insert a record with CMyColumn =
'TEST ENTRY' or 'test entry' or '   test entry   ' ...

> HTH.
I tried it out:
CREATE UNIQUE INDEX MySchema.MyIndexName
    ON MySchema.MyTable  upper(trim((CLOGINNAME)))
    TABLESPACE MyIndexTableSpace LOGGING;
No Problem to create that index, but, after it, still no problem to 
insert f.e. 'TEST ENTRY'

Any more idea?

> Cheers.
Thanks
> Carlos.
Andreas

-- 
wenn email, dann AndreasMosmann <bei> web <punkt> de