In the following query in SQLite
SELECT cfpref FROM cfprefs ORDER BY cfpref
I expect the output to be sorted in ASCII order. However, the output contains
GLAIC_TLC
GLAICSPW
in this order, even though underscore (_) in ASCII table is located after uppercase letters. Is it intentional, or is it a bug?
Aucun commentaire:
Enregistrer un commentaire