Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Get Qt Extensions
  • Unsolved
Collapse
Brand Logo
  1. Home
  2. Qt Development
  3. General and Desktop
  4. Qt SQLite plugin building / Case-insensitive matching of Unicode characters in SQLite

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

Scheduled Pinned Locked Moved Solved General and Desktop
sqlsqlitepluginbuildsource
4 Posts 2 Posters 2.3k Views
  • 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.
  • M Offline
    M Offline
    michalos
    wrote on 9 Jan 2017, 13:21 last edited by
    #1

    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
    0
    • M Offline
      M Offline
      mrjj
      Lifetime Qt Champion
      wrote on 9 Jan 2017, 13:24 last edited by
      #2

      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
      1
      • M Offline
        M Offline
        michalos
        wrote on 9 Jan 2017, 13:41 last edited by
        #3

        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.

        M 1 Reply Last reply 9 Jan 2017, 14:10
        1
        • M michalos
          9 Jan 2017, 13:41

          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.

          M Offline
          M Offline
          mrjj
          Lifetime Qt Champion
          wrote on 9 Jan 2017, 14:10 last edited by
          #4

          @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
          2

          4/4

          9 Jan 2017, 14:10

          • Login

          • Login or register to search.
          4 out of 4
          • First post
            4/4
            Last post
          0
          • Categories
          • Recent
          • Tags
          • Popular
          • Users
          • Groups
          • Search
          • Get Qt Extensions
          • Unsolved