There are really three options. Pick one depending on the overall
business problem.

1. Make the index case insensitive (I think Firebird will do this with
ASCII #0-#127, but not characters over #128)

2. Force the column to uppercase in the application (This is how I
would do it since all my firebird work is in UTF-8)

3. Force the column to uppercase in a trigger

Check out some of the UDF libraries.

On Mon, 2005-07-11 at 05:14 -0700, Max Thorne wrote:
> Hi,
>
> how can I prevent a user from inserting duplicates in a table? For example I have table "company" with field "name" and a unique index for this field. However, a user can insert values like "Diesel Co.","DIESEL CO.", "diesel co.". Same company, different entries. Thanks!
>
> Max
>
>
>
> ---------------------------------
> Yahoo! Mail for Mobile
> Take Yahoo! Mail with you! Check email on your mobile phone.
>
> [Non-text portions of this message have been removed]
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>