Sample Header Ad - 728x90

Text string stored in SQLite Integer column?

13 votes
1 answer
18745 views
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