Re: Collation rules and multi-lingual databases

Dennis Gearon <gearond(at)fireserve(dot)net> writes:

> I think it would be nice, and I may write it eventually, to have a function
> called:
>
> COLLATION_VALUE( 'string', 'encoding' )

Indeed that would be really nice. I wish I had that and a pony.

Unfortunately my understanding is that the collation rules are simply too
complex to allow such a function in general. It's too bad because it would
indeed eliminate a lot of the problems in a single swoop.

Hm. But perhaps I can come up with such a function for the few collation
domains I care about. I think English is just a matter of making it case
insensitive, and fr_xx is just a matter of squashing accents. In which case I
should be able to do it myself.

--
greg