difference between VARCHAR NVARCHAR in SQLite

What is the difference betwee开发者_开发技巧n varchar and nvarchar in SQLite

In Microsoft SQL Server, VARCHAR is ASCII and NVARCHAR is Unicode (UTF-16). In SQLite, all text is Unicode, so it's not relevant. In any case, SQLite is loosely typed so it wouldn't make a difference anyways. See http://www.sqlite.org/datatype3.html:)