Question

Which order relational databases sort string literals in when executing following query:

SELECT ... FROM ... ORDER BY ... ASC;

Let's consider ASCII encoding and latin alphabet for simplicity considerations.

Cosmo · Accepted Answer

In computer systems (and in databases in particular) every character has a numeric value associated with it. Characters are sorted according to their respective numeric values.

Cosmo · Accepted Answer

Symbols, digits, uppercase letters, lowercase letters

Cosmo · Answer

Symbols, lowercase letters, digits, uppercase letters

Cosmo · Answer

Symbols, digits, lowercase letters, uppercase letters

Cosmo · Answer

Digits, uppercase letters, lowercase letters, symbols

Cosmo · Answer

Symbols, digits, letters (case insensitive)

Follow CodeGalaxy

Mobile Beta