mardi 13 janvier 2015

Sorting order in SQLite

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