summaryrefslogtreecommitdiff
path: root/src/lib/sqlite_database.cc
diff options
context:
space:
mode:
Diffstat (limited to 'src/lib/sqlite_database.cc')
-rw-r--r--src/lib/sqlite_database.cc19
1 files changed, 19 insertions, 0 deletions
diff --git a/src/lib/sqlite_database.cc b/src/lib/sqlite_database.cc
index f0270129b..e1ad15143 100644
--- a/src/lib/sqlite_database.cc
+++ b/src/lib/sqlite_database.cc
@@ -24,6 +24,20 @@
#include <sqlite3.h>
+using std::string;
+
+
+static
+int collator_compare(void* context, int length_a, const void* string_a, int length_b, const void* string_b)
+{
+ auto collator = reinterpret_cast<Collator*>(context);
+ return collator->compare(
+ string(reinterpret_cast<char const*>(string_a), length_a),
+ string(reinterpret_cast<char const*>(string_b), length_b)
+ );
+}
+
+
SQLiteDatabase::SQLiteDatabase(boost::filesystem::path path)
{
#ifdef DCPOMATIC_WINDOWS
@@ -36,6 +50,11 @@ SQLiteDatabase::SQLiteDatabase(boost::filesystem::path path)
}
sqlite3_busy_timeout(_db, 500);
+
+ rc = sqlite3_create_collation(_db, "unicode", SQLITE_UTF8, &_collator, collator_compare);
+ if (rc != SQLITE_OK) {
+ throw std::runtime_error("Could not set SQLite database collation");
+ }
}