Qt SQLite plugin building / Case-insensitive matching of Unicode characters in SQLite
-
Hi,
I need my SQLite database to sort my data with keeping the national characters in mind (polish letters).
Right now, when I use ORDER BY, the db sorts the letters provided by ASCII table of signs and adds the words starting with polish letters like Ą, Ż, Ś, Ć at the end of the query list.
I've done some reading, and I found that combining SQLite with an ICU plugin does the trick.
Alternatively I can compile the Qt SQLite plugin like mentioned here :
QT SQlite and ICU .
So I would like to folow the instruction on qt.io, but on http://doc.qt.io/qt-5/sql-driver.html is written, that I should have the plugin somewhere in "$QTDIR/qtbase/src/plugins/sqldrivers/sqlite".
I have sources for Qt 5.6.2 and Qt 5.7.1 but there is no folder called "plugins' there.
Did I misunderstood something, or is the info outdated? -
Hi
It sounds right.
On my system ( mingw)
its in
C:\Qt\5.7\Src\qtbase\src\plugins\sqldrivers\sqlite
There is the sqlite.pro file. -
-
@michalos
Well knowing windows searching, i always cheat and use
https://www.voidtools.com/
On NTFS drives, it will find anything really fast and takes wildcards.
Its only for filenames but on the other hand, it finds a file in secs even on a 4 TB drive. :)
