difference between VARCHAR NVARCHAR in SQLite

来源:互联网 发布:淘宝开店装修免费模板 编辑:程序博客网 时间:2024/06/05 17:12

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

原创粉丝点击