On Sat, Sep 13, 2008 at 2:02 AM, Stewart Smith <[EMAIL PROTECTED]> 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? > -- > Stewart Smith > For the sake of argument, wouldn't the ideal way to deal with per index collations be to use a functional index using convert (which IIRC has been ripped out of Drizzle, or at least that is under discussion). MySQL does not have functional indexes at this point, however evidently there is a set of patches out there that implement them: http://datacharmer.blogspot.com/2008/09/mysql-virtual-columns.html For that matter, shouldn't functional index be able to make Sheeri's desc index issue go away? -- Rob Wultsch
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
