I am trying to find a "non-weird" character to force nulls to sort last on a text field. In other words:
ifnull(myfield,'X none'), where X is some character that sorts beyond Z.
I have tried many, and I am only finding foreign characters sorting higher.
It seems like the text sort (ascending) is neither ASCII nor unicode.
Ideas?
