开发者

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜