Quote:
Originally Posted by knc1
- - - - -
And then again...
So try following the sqlite.org directions, and:
Code:
[root@kindle local]# sqlite3 cc.db
SQLite version 3.7.14.1 2012-10-04 19:37:12
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .dump Locale
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE Locale ( locale );
INSERT INTO "Locale" VALUES('en_US.utf8');
COMMIT;
sqlite> SELECT * FROM Locale;
en_US.utf8
sqlite> SELECT icu_load_collation('en_US.utf8', 'icu');
Error: no such function: icu_load_collation
sqlite>
????
Well, the answer to that one happens to be on the first line shown above.
SQLite version 3.7.14.1 2012-10-04 19:37:12
The ability to load a custom collation was first added to sqlite3, version 3.7.16
The current version is 3.21
My Ubuntu LTS has 3.20 installed.
So the most likely situation is the (?contractor?) person at Lab126 is doing all of s/he's work on a PC (with a current or nearly current version) and never checking their work on the Kindle.
Update:
The above was from 5.9.2 -
A similar problem exists on 5.3.7.3 (the oldest ts firmware version we support here).
I.E: The interactive sqlite3 can not delete records from cc.db for the same reason (the extension library might be able to but not the interactive). |
Whoot!
A build of SQLite3 (3.21.0 the newest) that runs on our oldest, supported, touchscreen model, the KT-fw5.3.7.3:
Code:
[root@kindle local]# cat /etc/prettyversion.txt
Kindle 5.3.7.3 (~~otaVersion~~)
[root@kindle local]# LD_LIBRARY_PATH=/var/local ./sqlite3.armv7a
SQLite version 3.21.0 2017-10-24 18:55:49
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite>
The library path thingy is because the Kindles are missing a library that is required.
Which really isn't all that bad, only one additional file required to make today's sqlite3 version run on our oldest supported model/firmware combination.
Tomorrow - return to the "get rid of the KUAL booklet" script writing.