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.
  • michalosM Offline
    michalosM Offline
    michalos
    wrote on 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
    • mrjjM Offline
      mrjjM Offline
      mrjj
      Lifetime Qt Champion
      wrote on 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
      • michalosM Offline
        michalosM Offline
        michalos
        wrote on 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.

        mrjjM 1 Reply Last reply
        1
        • michalosM michalos

          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.

          mrjjM Offline
          mrjjM Offline
          mrjj
          Lifetime Qt Champion
          wrote on 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

          • Login

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