移动平台数据库的一些限制（EDB、CEDB、SQL CE）

Feature EDB CEDB SQL Server CE 2.0 Maximum volume size 64 MB 16 MB 2.14 GB Maximum record size 8 KB (excluding stream data) 128 KB 4 KB Maximum number of properties per database 1,024 No limit 255 Maximum property name length 128 characters Not supported 128 characters Maximum volume name length (MAX_PATH - 13) characters MAX_PATH flag 128 characters Maximum number of sort orders 16 4 249 Maximum number of properties in a sort order or index 16 3 10 Maximum key length in a sort order or index 512 bytes 512 bytes 510 bytes Default lock escalation value 100 Not supported Not supported Maximum number of concurrent transactions 255 Not supported Not supported Maximum password length 40 characters Not supported 40 characters Maximum number of open database handles 256 Not supported Not supported