I'm a database novice looking at an SQLite database which appears to be storing text in an integer column. Here's an example session at the sqlite3 command line:
sqlite> .schema mytable
CREATE TABLE mytable (
id integer primary key, /* 0 */
mycol integer not null, /* 1 */
);
sqlite> SELECT mycol FROM mytable;
here is some text
here is more text
[...]
it's text all the way down
I'm confused. What gives?
Asked by igal
(345 rep)
Jul 8, 2015, 05:07 PM
Last activity: Mar 25, 2020, 09:17 PM
Last activity: Mar 25, 2020, 09:17 PM