Doing sorting that is case insensitive
Mackram Raydan <[email protected]> Sun, 13 Feb 2011 00:41:39 +0200
| Newsgroups | gmane.lisp.clsql.general |
|---|---|
| Message-ID | <[email protected]> |
Hey Everyone, I was just wondering if there was a way to make clsql requests be case insensitive specifically when doing an order-by. My understanding that adding the word binary right after the order section of a mysql statement will force mysql to do the sorting as case insensitive so is there a way to tell the select function in clsql to add that binary directive. I have only done a search on Google about the subject and have came up empty handed (ie I did not have time yet to read the code). So any help that could save me some time would be much appreciated. Thanks in advance. Mackram Raydan