Skip to content
Advertisement

Tag: ebcdic

Reverse EBCDIC sorts numbers before letters in ROW_NUMBER function

So I do have following SQL select Key is of the type VARCHAR(12). I wonder why the hell the numbers are sorted after the letters. Every other system including UTF-8 always begins with numbers. Answer So a solution you can do is to take advantage of the EBCDIC character order. Special characters are sorted before the letters! If the numeric

Advertisement