pugboy Posted May 11, 2009 Share Posted May 11, 2009 Anyone know what the "order" of the characters are when using MySQL's order by feature? The "-" character seems like it is before "/", and I would like to know if I can change the order in which the rows are ordered. If it doesn't make much sense to you: "A" comes before "B" when using ORDER BY, but how do the other non-Alphanumeric characters get ordered? Quote Link to comment https://forums.phpfreaks.com/topic/157642-solved-order-by-order-of-characters/ Share on other sites More sharing options...
PFMaBiSmAd Posted May 11, 2009 Share Posted May 11, 2009 http://www.asciitable.com/ Quote Link to comment https://forums.phpfreaks.com/topic/157642-solved-order-by-order-of-characters/#findComment-831273 Share on other sites More sharing options...
fenway Posted May 11, 2009 Share Posted May 11, 2009 This is also collation-specific. Quote Link to comment https://forums.phpfreaks.com/topic/157642-solved-order-by-order-of-characters/#findComment-831562 Share on other sites More sharing options...
pugboy Posted May 11, 2009 Author Share Posted May 11, 2009 Hmm... Thanks. Time to change what character I use :/ Quote Link to comment https://forums.phpfreaks.com/topic/157642-solved-order-by-order-of-characters/#findComment-832031 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.