What is the difference between varchar and nvarchar in SQLite
+2
A:
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:)
Daniel15
2010-10-14 06:05:58
Moreover SQLite will never enforce length specifications. If you declare a column as CHAR(n), VARCHAR(n), TEXT or STRING or (…) it has no length limitation.
Benoit
2010-10-14 06:22:03