Re: Best way to store case-insensitive data?

Please don't top-post.

Mike Christensen wrote:
> Ah, I should probably upgrade to 8.4. However, I'll probably just
> wait for 9.0 to come out. So it seems like citext will be about the
> same as casting both sides to LOWER(), plus putting an index on the
> lowercase version of the text. I'd probably use that if it were out
> of the box, but I'm trying to stay away from adding too many
> dependencies.. I think I'll stick with my original approach of only
> storing lowercase data in the DB, and perhaps put a CHECK constraint
> on there to ensure no upper case letters sneak in.

If your db contains international text there are some corner cases where
lower( upper( val )) != val or upper( lower( val )) != val. Or there should
be, because that's what happens in certain languages.

For example, upper-case 'ß' should be 'SS' in German. Lower-case 'SS' is 'ss'.

--
Lew