SQLite ORDER BY gives wrong order with language specific text (C#) -


i have sqlite database, contains many data.
data order by, contains english letters , Á, É, Í, etc.
i'm using query:

select * `tablename` order `columnname`; 

it gives wrong order: a-z, Á, É, Í, etc.
but, correct order: a, Á, b-e, É, f-i, Í, etc.

i'm using query through c# application.

thanks help:
horbert

p.s.: it's hungarian language, else.


Comments