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?


  • Qt Champions 2016

    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.



  • Thank You very much!

    I've looked in the first src folder and used windows 'search', but did not look in the qtbase dir.
    The path on qt.io is correct.
    My mistake.


  • Qt Champions 2016

    @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. :)



Looks like your connection to Qt Forum was lost, please wait while we try to reconnect.