Menu
Community /Pin to ProfileBookmark
@NogDogApr 21.2009 — #If we're talking about a database query sort, what collation type is that column using? @NogDogApr 22.2009 — #Where is the actual sorting done: JavaScript, PHP, a database query, or somewhere else? We cannot figure out how to fix the sorting without knowing how it's currently being done. If it can be done at the database level, that may be the easiest place to deal with it as it may only be a matter of specifying an appropriate character collation (e.g. utf8-general-ci in MySQL). Doing the sort in PHP may be more of an issue as it does not "play well" with multi-byte character sets (at least not until PHP6 is ready, hopefully) and may require more work to get it to sort the way you want (perhaps utilizing the [url=http://www.php.net/mbstring]mbstring[/url] extension).
If the sorting is done at the JavaScript level, then this should probably be moved to the JavaScript forum.
How can i Sort with accents?
My prob is, when i put my table to sort for name (alphabetical order), it doesnt count the words with accents, it sort all normal but the words with accents came in the end of that letter like this:
i have the words with M
Mike
Mongrell
Mário
“mário” should be first than the others but cause of the accent it came in last.
what i need is something that can order normaly with accents too
Sign in
to post a comment6 Comments(s) ↴
0
@NogDogApr 21.2009 — #0
@NogDogApr 22.2009 — #Where is the actual sorting done: JavaScript, PHP, a database query, or somewhere else? We cannot figure out how to fix the sorting without knowing how it's currently being done. If it can be done at the database level, that may be the easiest place to deal with it as it may only be a matter of specifying an appropriate character collation (e.g. utf8-general-ci in MySQL). Doing the sort in PHP may be more of an issue as it does not "play well" with multi-byte character sets (at least not until PHP6 is ready, hopefully) and may require more work to get it to sort the way you want (perhaps utilizing the If the sorting is done at the JavaScript level, then this should probably be moved to the JavaScript forum.