Comments (4)
I think you may try using WxSQLite3 plugin for the database connection and then add the SELECT icu_load_collation('pl_PL', 'POLSKI');
to initialization/configuration SQL, while keeping the "password" empty, to avoid encrypting with WxSQLite3, somthing like this:
from sqlitestudio.
Have you already tried the icu extension and the Collation editor menu option?
from sqlitestudio.
Have you already tried the icu extension and the Collation editor menu option?
Hi. Thank you for you reply.
I have ICU extension installed and and have Collation Editor in the menus.
I tried it but haven't been able to figure out how. The documenation lacks explanation on how to use it, and shows no working example. In the end I gave up.
Thankfully I then went to sqlite documentation, specifically to ICU readme file, and found out about icu_load_collation
command, so I started SQL editor and ran:
SELECT icu_load_collation('pl_PL', 'POLSKI');
which created collation named POLSKI
, which I then used in my tables, and voila - I now have proper sorting. Exactly what I wanted.
However, as I restarted the program it told me no such collation: POLSKI
forcing me to re-run above SQL command.
Is there a way to make a collation created with icu_load_collation
persistent or to auto-execute SQL commands on program startup?
Please, advise.
Thank you.
from sqlitestudio.
Is there a way to make a collation created with icu_load_collation persistent
No.
or to auto-execute SQL commands on program startup?
I don't think it's supported.
Probably in your simple case a simple JavaScript collation definition would be enough (but probably much slower than ICU):
return arguments[0].localeCompare(arguments[1], 'pl')
from sqlitestudio.
Related Issues (20)
- formatted viewers
- cannot create new database HOT 3
- Tree node disappeared if drag it to query editor HOT 2
- no database name and table name on the dashboard HOT 2
- Help! SQLite Studio wont work on my macbook pro HOT 1
- advise add the remote access sqlite database capabilities
- Loading BLOB data from file
- qt.qpa.plugin: Could not load the Qt platform plugin "xcb" in "" even though it was found. HOT 1
- The sqlitestudio binary does not have the correct rpath set
- Cannot view files in SQL save function HOT 2
- import data tool Feature request HOT 3
- Execute sql from a file errors
- [21:23:28] Could not add database SimSim: Could not open database: unable to open database file
- Import and Export functions unusable in SQLiteStudio-3.4.4-windows-x64
- Strange intermittent bug when running SELECT: "1st ORDER BY term out of range - should be between 1 and 1"
- Error on OS/2
- Table copy between two databases by drag HOT 1
- Opening a large database in SQLiteStudio takes long time
- Build breaks on arm64: error: unsupported option '-msse4.1' for target 'aarch64-unknown-freebsd15.0'
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from sqlitestudio.