difference between VARCHAR 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

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. Seehttp://www.sqlite.org/datatype3.html:)

在sql Server中，VARCHAR是ASCII编码而NVARCHAR是Unicode编码（UTF-16）. 在sqlite中，所有的文本都是Unicode，所以VARCHAR和NVARCHAR没什么区别。sqlite的类型是松散的，所以不会有很大的不同，详见http://www.sqlite.org/datatype3.html

原文地址：http://stackoverflow.com/questions/3930501/difference-between-varchar-nvarchar-in-sqlite

总结

以上是内存溢出为你收集整理的difference between VARCHAR NVARCHAR in SQLite全部内容，希望文章能够帮你解决difference between VARCHAR NVARCHAR in SQLite所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。