2. PHPRunner General questions
  3. What major difference between database encryption and code based encryption in PHPR 7.0 Enterprize var?
This topic is locked

What major difference between database encryption and code based encryption in PHPR 7.0 Enterprize var?

 		4/4/2014 8:48:18 AM
PHPRunner General questions
A
 Abul author

Can any one explain me what actually difference between "database encryption" and "code base encryption" methods in PHPRunner 7.0 enterprize version? Because manual suggests to adopt database encryption for better feature. Manual does not explain in detail. I have a problem with my production remote server where their Mysql server does not allow database encryption due to security instead of code base encryption. Thanks in advance.
Sergey Kornilov admin 4/4/2014

A quote from http://xlinesoft.com/phprunner/docs/encryption.htm

"Database-based method is recommended since some features will not work in case of code-based method: encrypted fields are not involved in the sorting and grouping, search suggest and search with all search operators other than Equal will not work etc. So make sure you encrypt really important data."
For instance, if you encrypt SSN numbers using code based encryption you won't be able to perform partial search or sort data by this field.
A
 		Abul author 4/4/2014



A quote from http://xlinesoft.com/phprunner/docs/encryption.htm

"Database-based method is recommended since some features will not work in case of code-based method: encrypted fields are not involved in the sorting and grouping, search suggest and search with all search operators other than Equal will not work etc. So make sure you encrypt really important data."
For instance, if you encrypt SSN numbers using code based encryption you won't be able to perform partial search or sort data by this field.


Then I think code based encryption is better than database in concern security hole.