Veysel Harun Sahin <[EMAIL PROTECTED]> wrote:
I have already started using sqlite. The version which i use is 3.2.7. I have no problems except sorting. When i query a table using the "order by" clause i can not get true sorting according to iso8859-9 charset. The special characters of my encoding are seen at the end of the list. What can i do to overcome this problem?
You define a custom collation function with sqlite3_create_collation[16] or sqlite3_collation_needed[16], then specify it with a COLLATE clause in your query.
Igor Tandetnik
