say I have a table 't1' with a string column 'name'. And I have names 'n1','n2','n9' and 'n:'. If I do
select * from t1 orderby name asc
I expect
n1
n2
n9
n:
Given that ':' comes after '9' in ASCII, but instead, I get
n:
n1
n2
n9
Which is a surprise. Is there something I need to do to say 'use ASCII as the collating sequence for basic ASCII chars'