> -----Original Message----- > From: Jay Macaulay [mailto:[EMAIL PROTECTED] > Sent: Friday, February 27, 2004 10:56 AM > > Another solution that would allow using an index would be to > add another > column, flatname, and insert the name into that column > without any accents > while still inserting the real name with accents into a > different column, > then do an order by on that flatname column. This will allow > you to order > it and still retain your indices, at the cost of an extra column.
Yes, that's perhaps what I would do in this situation, creating INSERT/UPDATE triggers to make sure the integrity of the column is maintained. -Ken --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]