sql - SQLite ORDER BY query returns two different orderings? -

sql - SQLite ORDER BY query returns two different orderings? -

i have 2 databases have lot of similar values. namely, have unique key, let's phone call uid.

in table 1 have these 2 keys

blahblahblahyebaaa= blahblahblahyebaaa=

and in table 2 have same 2 keys.

now when search query uniquekey = blahblahblahyebaaa= ordered unique key,

for both databases these 2 keys (not sure why it's not case sensitive) , ordering exclusively different. database 1 baaa=, baaa= , database 2 reverse ordering. ordering interfering programme i'm writing compare these values, ideas how ordering match up?

you can utilize collate binary create ordering case-sensitive:

order {key} collate binary

and filtering:

where key = 'blahblahblahyebaaa' collate binary

sql sqlite