Project

General

Profile

Feature #1205

Use UTF-8 as default sqlite encoding

Added by j0s almost 12 years ago. Updated almost 11 years ago.

Status:
Rejected
Priority:
Normal
Assignee:
-
Category:
-
Target version:
-
Start date:
03/04/2013
Due date:
% Done:

0%

Estimated time:
OS:
Any

Description

I use a self compiled quasselcore 0.8.0 on Debian squeeze.
Over the last days I created a script to move logs older than 14 days to a second db.
The database seemed still quite large after this (and VACUUM; obviously) so I took a closer look.
It seems the database gets created as UTF-16.
Since most of the chat on IRC is 7-Bit-ASCII anyway (at least for me), it would make much more sense to use UTF-8.
I converted my database to UTF-8 and it works just fine.
My old logs for example only have 301MiB as UTF-8 sqlite database but 488MiB as UTF16le.
I suggest to set the default db format to UTF-8 by issuing "PRAGMA encoding = "UTF-8";" before creating the database and maybe make this an option somewhere with UTF-8 the default!

History

#1 Updated by al almost 11 years ago

  • Status changed from New to Rejected

Couldn't reproduce the issue today, a freshly created quassel-storage.sqlite is UTF-8 encoded.

$ sqlite3 ~/.config/quassel-irc.org/quassel-storage.sqlite 'pragma encoding;'
UTF-8

Closing for now, please re-open with further information if you can reproduce this.

Also available in: Atom PDF