我不确定加密,但您可能会发现此链接很有帮助:
http://msdn.microsoft.com/en-us/library/ms171955.aspx http://msdn.microsoft.com/en-us/library/ms171955.aspx
至于其余部分:
“Text”和“auto_increment”让我想起了Access。 SQL Server Compact 应该升级兼容serverSQL Server 版本中,紧凑型数据库中使用的查询和表应无需修改即可转移到完整数据库。考虑到这一点,您应该首先查看SQL Server 类型和名称 http://msdn.microsoft.com/en-us/library/ms172424.aspx而不是访问名称:在这种情况下即varchar(max)
, bigint
, and identity
列。
Unfortunately, you'll notice this fails with respect to varchar(max), because Compact Edition doesn't yet have the varchar(max) type. Hopefully they'll fix that soon. However, the ntext type you were looking at supports many more than 255 bytes: 230 in fact, which amounts to more than 500 million characters.
Finally, bigint uses 8 bytes for storage. You asked for 11. However, I think you may be confused here that the storage size indicates the number of decimal digits available. This is definitely NOT the case. 8 bytes of storage allows for values up to 264, which will accomodate many more than 11 digits. If you have that many items you probably want a server-class database anyway. If you really want to think in terms of digits, there is a numeric
type provided as well.