SQLite and sorting of unicode strings
Unsolved
General and Desktop
-
Hi,
I need to get some strings from my DB table (SQLite database) sorted by unicode characters. This means sorting in order a, á, b, c, č, d, ď, e, é, ě etc.
I read this guide http://www.mimec.org/node/296. But it is quite old and mentions some Qt limitations. Which of the still apply? What should I use with current Qt 5.2. I need support for Windows, Linux and Android at least.
Is there a universal solution? Or should I rather simply remove the accents and sort without them?
Thank you!