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.