Re: specific collation issue

[Peter Gulutzan]

We usually suggest filing feature requests
requests to bugs.mysql.com (not bugs.yahoo.com).
And yes, an official document makes it credible.
But realistically, there's little chance
we'll consider a special collation for this.
And Alef U+A723 is a relatively recent addition, in
Unicode 5.1, which we don't officially support yet.

You could create a transliterating function to use
in every ORDER BY or WHERE clause, but that's not
fast, since MySQL wouldn't use an index for it.

Indeed a separate column looks like the solution.


Peter Gulutzan
MySQL / Oracle