Re: Switching between case sensitive and case insensitive string comparison

Keppa <[EMAIL PROTECTED]> wrote:
[...]
> Each row is uniquely identified with the integer ID and the object
> name field.

I don't think that the way you're doing this makes much sense.  You
really should consider dropping all the duplicate key stuff and making
the actual unique identifier (ID + name) the (non-duplicate) primary
key.  That way, you get to have all the information about the
case-sensitivity of the name part of the key in *one* place: the
comparison function.

-- 
Hans-Bernhard Broeker ([EMAIL PROTECTED])
Even if all the snow were burnt, ashes would remain.