Corrections to base64 encoding function by apjarvis · Pull Request #1804 · sqlitebrowser/sqlitebrowser
You can try with the following sample data:
CREATE TABLE "demodata" ( "clientid" INTEGER, "date" TEXT DEFAULT CURRENT_DATE, "weekdays" TEXT, "gains" TEXT, "prices" TEXT, "up" TEXT, "bindata" BLOB ); INSERT INTO "main"."demodata" ("clientid", "date", "weekdays", "gains", "prices", "up") VALUES ('0', '2008-04-30', 'Wed', '-0.52458192906686452', '7791404.0091921333', 'False'); INSERT INTO "main"."demodata" ("clientid", "date", "weekdays", "gains", "prices", "up") VALUES ('1', '2008-05-01', 'Thu', '0.076191536201738269', '3167180.7366340165', 'True'); INSERT INTO "main"."demodata" ("clientid", "date", "weekdays", "gains", "prices", "up") VALUES ('2', '2008-05-02', 'Fri', '-0.86850970062880861', '9589766.9613829032', 'False'); INSERT INTO "main"."demodata" ("clientid", "date", "weekdays", "gains", "prices", "up") VALUES ('3', '2008-05-03', 'Sat', '-0.42701083852713395', '8949415.1867596991', 'False'); INSERT INTO "main"."demodata" ("clientid", "date", "weekdays", "gains", "prices", "up") VALUES ('4', '2008-05-04', 'Sun', '0.2532553652693274', '937163.44375252665', 'True'); INSERT INTO "main"."demodata" ("clientid", "date", "weekdays", "gains", "prices", "up") VALUES ('5', '2008-05-05', 'Mon', '-0.68151636911081892', '949579.88022264629', 'False'); INSERT INTO "main"."demodata" ("clientid", "date", "weekdays", "gains", "prices", "up") VALUES ('6', '2008-05-06', 'Tue', '0.0071911579626532168', '7268426.906552773', 'True'); INSERT INTO "main"."demodata" ("clientid", "date", "weekdays", "gains", "prices", "up") VALUES ('7', '2008-05-07', 'Wed', '0.67449747200412147', '7517014.782897247', 'True'); INSERT INTO "main"."demodata" ("clientid", "date", "weekdays", "gains", "prices", "up") VALUES ('8', '2008-05-08', 'Thu', '-1.1841008656818983', '1920959.5423492221', 'False'); INSERT INTO "main"."demodata" ("clientid", "date", "weekdays", "gains", "prices", "up") VALUES ('9', '2008-05-09', 'Fri', '-1.5803692595811152', '8456240.6198725495', 'False'); INSERT INTO "main"."demodata" ("clientid", "date", "weekdays", "gains", "prices", "up") VALUES ('10', '2008-05-06', 'Tue', '0.0071911579626532168', '7268426.906552773', 'True'); INSERT INTO "main"."demodata" ("clientid", "date", "weekdays", "gains", "prices", "up") VALUES ('11', '2008-05-07', 'Wed', '-0.86850970062880861', '9589766.9613829032', 'False'); INSERT INTO "main"."demodata" ("clientid", "date", "weekdays", "gains", "prices", "up") VALUES ('12', '2008-05-03', 'Sat', '-0.42701083852713395', '8949415.1867596991', 'False'); INSERT INTO "main"."demodata" ("clientid", "date", "weekdays", "gains", "prices", "up") VALUES ('13', '2008-05-05', 'Mon', '-0.68151636911081892', '949579.88022264629', 'False'); INSERT INTO "main"."demodata" ("clientid", "date", "weekdays", "gains", "prices", "up") VALUES ('14', '2008-05-06', 'Tue', '0.0071911579626532168', '7268426.906552773', 'True'); INSERT INTO "main"."demodata" ("clientid", "date", "weekdays", "gains", "prices", "up") VALUES ('15', '2008-05-07', 'Wed', '0.67449747200412147', '7517014.782897247', 'True'); INSERT INTO "main"."demodata" ("clientid", "date", "weekdays", "gains", "prices", "up") VALUES ('16', '2008-05-08', 'Thu', '-1.1841008656818983', '1920959.5423492221', 'False'); INSERT INTO "main"."demodata" ("clientid", "date", "weekdays", "gains", "prices", "up") VALUES ('17', '2008-05-09', 'Fri', '-1.5803692595811152', '8456240.6198725495', 'False');
In bindata, insert whatever file or data you want.