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? 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/ 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. 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 :/ 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
Archived
This topic is now archived and is closed to further replies.