What's the best record datatype to store a file-path in SQLite?
Which data type in SQLite is best suited to storing a file 开发者_如何学编程path?
sqlite3 supports varchar(n), but doesn't enforce the 'n'.
sqlite> create table test (fullpath varchar(10) primary key);
sqlite> insert into test values ('/usr/local/bin/sqlite3');
sqlite> select * from test;
/usr/local/bin/sqlite3
This is a frequently asked question.
精彩评论