CODEWITHSUNDEEP
androidobjective-csqlite
user1790048
user1790048

Reputation: 21

Sqlite order by special characters

I executed an SQLite query, but I got a result that is not in the order that we need,the character "á" is being shown after z.

How can I configure my query to ignore special characters?

Upvotes: 2

Views: 684

Answers (1)

PCM
PCM

Reputation: 873

Not sure if you just want to ignore all the results having these special characters or you have difficulties in sorting the result.

You can treat this as a hint (not an answer):

SELECT * 
FROM _table-name_ 
WHERE _column-name_ COLLATE Latin1_General_BIN NOT LIKE '%[^ a-zA-Z]%'

Upvotes: 1

Related Questions