Stewart Smith wrote:
On Wed, Aug 13, 2008 at 10:57:58PM -0700, Monty Taylor wrote:
On the other hand, if there was a per-server collation set by locale,
would that be sufficient?
What about per-index?
Thinking about presentation of a data set for different locales. e.g. I
want it sorted the way i expect it, but somebody viewing in $language
probably wants it in their collation.
Is this a sensible idea or am I just completely missing the issues?
Per index is reasonable, but the case where the declare collation for
the index is different from the effective collation of the connection.
They the collations are different, the index can be used for equality
retrievals (99% of all retrievals anyway) but not for range retrieval or
for optimizing a sort.
I think this is the way it has to work.
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
