Re: [sqlite] Trouble about ordering records by name (or any varchar column)

2011-10-19 Thread Jean-Christophe Deschamps
In my SQLite 3 Database, I have some records with Turkish characters such as "í", "Ü", "İ" etc. When I select my values with SELECT * FROM TABLE ORDER BY COLUMN_NAME query, the records that begin with these characters are coming at the end. Bare bone SQLite only collates correctly on

[sqlite] Trouble about ordering records by name (or any varchar column)

2011-10-19 Thread Kubilay Erdogan
Hi all, I'm having some trouble about ordering records by name (or any varchar column). I first asked for help at StackOverFlow(I wasn't aware of this list) then had to dig out more. In my SQLite 3 Database, I have some records with Turkish characters such as "Ö", "Ü", "İ" etc. When I select