I'd like to have a table in MySQL with the key field being a 12-character text string consisting of digits and upper-case letters (minus the vowels and Y, to prevent accidental bad words), i.e. something like:
XM39C6B4... When I do queries and get back result sets sorted on this text string, is it always safe to assume that: a)Digits come before letters? b)Letters are in ascending order, i.e. A before B, B before C, etc.? To be conservative, should I set collation order? Thanks.