为什么 SQL Server CE 不支持 varchar? [英] Why doesn't SQL Server CE support varchar?

问题描述

我在 SQL Server CE 中创建了一个表，发现它不支持 varchar.

I was creating a table in SQL Server CE and realized it doesn't support varchar.

查了一下，发现不支持非Unicode文本列(varchar、char、text)和smallmoney；虽然支持nvarchar、nchar、ntext和money"为在 MSDN 中说明.

Looking this up, I found that "non-Unicode text columns (varchar, char, text) and smallmoney are not supported; although nvarchar, nchar, ntext, and money are supported" as stated at MSDN.

这是真的吗?这是为什么?看起来紧凑 数据库将支持需要更少字节 来存储的数据类型...我假设它需要更多空间来保存Unicode 字符.

Is this true? Why is this, exactly? It would seem that a compact database would support data types that take less bytes to store...I'm assuming it takes more space to save the Unicode characters.

这背后的原因是什么?

推荐答案

这可能是因为 Windows CE 是完全基于 Unicode 的，并且它的所有字符串都以这种方式存储.

It's probably because Windows CE is completely Unicode based and all of it's strings are stored that way.

这篇关于为什么 SQL Server CE 不支持 varchar?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！