Qt Forum

    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Search
    • Unsolved

    Qt Academy Launch in California!

    Solved Qt SQLite plugin building / Case-insensitive matching of Unicode characters in SQLite

    General and Desktop
    sql sqlite plugin build source
    2
    4
    1942
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • michalos
      michalos last edited by

      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?

      1 Reply Last reply Reply Quote 0
      • mrjj
        mrjj Lifetime Qt Champion last edited by

        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.

        1 Reply Last reply Reply Quote 1
        • michalos
          michalos last edited by

          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.

          mrjj 1 Reply Last reply Reply Quote 1
          • mrjj
            mrjj Lifetime Qt Champion @michalos last edited by

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

            1 Reply Last reply Reply Quote 2
            • First post
              Last post