SQL Server Compact Edition v3.1 and most of the previous versions of SQL Server Mobile/CE use the RSA encryption standard to encrypt the contents of the database files when you use the "Encrypt=true" connection string option. In the case of v3.1, 128-bit RSA is used (I'm not sure about the number of bits in earlier versions).
For quite some time, people have been asking that stronger encryption options be supported. You will be happy to hear, that SSCE v3.5 now offers new encryption support.
Starting with SSCE v3.5, Windows Mobile 5.0 & Windows Mobile 6 devices now encrypt the db files using {SHA1, AES128}. Windows CE 4.2 (the OS under PPC2003 SE devices) doesn't support AES128 so SSCE db files on PPC 2003SE devices are encrypted using {SHA1, 3DES}.
Posted
Jul 31 2007, 08:02 AM
by
jim-wilson