Re^2: dbi::CSV works with text, but not numbers

Replies are listed 'Best First'.
Re^3: dbi::CSV works with text, but not numbers by Marshall (Canon) on May 20, 2016 at 11:50 UTC
I also highly recommend the Firefox add-in in my original post. That thing is amazingly good! I just installed it on this Windows laptop that I'm using... Since Mozilla uses .sqlite files, you will be able to select under directories, say, cookies.sqlite. Under structure, it will tell you how that table was created: `CREATE TABLE moz_cookies (id INTEGER PRIMARY KEY, baseDomain TEXT, ori +ginAttributes TEXT NOT NULL DEFAULT '', name TEXT, value TEXT, host T +EXT, path TEXT, expiry INTEGER, lastAccessed INTEGER, creationTime IN +TEGER, isSecure INTEGER, isHttpOnly INTEGER, appId INTEGER DEFAULT 0, + inBrowserElement INTEGER DEFAULT 0, CONSTRAINT moz_uniqueid UNIQUE ( +name, host, path, originAttributes))` [download] Anyway if you have Firefox, you already have some SQLite DB's on your machine.	[reply] [d/l]

Replies are listed 'Best First'.

Re^3: dbi::CSV works with text, but not numbers
by Marshall (Canon) on May 20, 2016 at 11:50 UTC

Under structure, it will tell you how that table was created:

CREATE TABLE moz_cookies (id INTEGER PRIMARY KEY, baseDomain TEXT, ori
+ginAttributes TEXT NOT NULL DEFAULT '', name TEXT, value TEXT, host T
+EXT, path TEXT, expiry INTEGER, lastAccessed INTEGER, creationTime IN
+TEGER, isSecure INTEGER, isHttpOnly INTEGER, appId INTEGER DEFAULT 0,
+ inBrowserElement INTEGER DEFAULT 0, CONSTRAINT moz_uniqueid UNIQUE (
+name, host, path, originAttributes))
[download]

[reply]
[d/l]