Sqlite order by special characters

Question

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?

http://stackoverflow.com/questions/611459/how-to-sort-text-in-sqlite3-with-specified-locale — Lawrence Barsanti, Nov 01 '12 at 01:19

score 1 · Answer 1 · edited Nov 01 '12 at 01:04

1

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]%'

edited Nov 01 '12 at 01:04

wattostudios

answered Nov 01 '12 at 00:45

PCM

1 Answers1