Thread: How to obtain a good ASCII order ?

How to obtain a good ASCII order ?

From
eurlix
Date:
Hello all,

It seem to me that when a column contain non current characters
like "*" (052, X2A), ">" (076, X3E), etc ... pg gives it in a
non-ASCII ordered sequence.

When I know that some character may be appear volontary in the
first position of the column, I have found that I can have a good
result (for me) by "... order by substr(col,1,1), col ...) but
when I cannot presume this, how may I have a good sequence ?

Thanks,
--
Alain Lucari (Eurlix)