My recommendation is that you somehow force all data stored in that column to
the same case. It may not be a perfect solution but then, this problem strikes
me as rare enough that there may not be a better one.
Donald
-- Original message --
From: Ziad Mansouri
you're increasing your storage space, however, you can't have your cake
and eat it too.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 24, 2006 7:32 AM
To: Derby Discussion
Subject: Re: Unique case-insensitive constraint on a varchar column
-insensitive constraint on a varchar column
Ziad Mansouri wrote:
Mates,
I'm trying to create a constraint, on a varchar
column, which is case insensitive. Here's the table:
create table categories (
category_id int not null generated always as identity
primary key,
category
Derby should offer a case-insensitive operation mode.
This is something I have been asking for.
Here is the text of my feature request application. Feel free to support
this if you see the same need
Global case insensitive setting
---
Key: