I guess you best option would be the same as is sorting case insensitive,
make a copy of you name table convertit to simple lowercase no accents and
sort by that colum.
cheers
Juan carlos
On Mon, 4 Oct 1999, David Diaz i Torrico wrote:
> Hi,
>
> I want to sort words that contains characters over the "7-bit limit", like:
>
> Abús
> Alè
> Barrufet
> Capaç
> Àbac
>
> But appearing in that order:
>
> Abús
> Àbac
> Alè
> Barrufet
> Capaç
>
> Is mSQL able to sort non-standard ASCII characters in that way?
>
> It could be interesting to use different alphabetical tables for the many
> languages a server could support.
> -
> apa, siau!
> -------------------------------------------------------------------------
> To unsubscribe, go to http://www.Hughes.com.au/extras/email/
>
-------------------------------------------------------------------------
To unsubscribe, go to http://www.Hughes.com.au/extras/email/
This archive was generated by hypermail 2b30 : Mon Mar 04 2002 - 09:03:51 EST