2. PHPRunner General questions
  3. You can not encrypt a field in sql server with data encryption of PHPRunner
This topic is locked

You can not encrypt a field in sql server with data encryption of PHPRunner

 		3/17/2015 5:49:33 PM
PHPRunner General questions
pasquito author

Database server:

DB = Sql Server 2014 enterprise.
Development tool:

Tools = Php Runner 8.0 enterprise 64bits.
I tried encrypting a "nro_tarjeta_debito" varchar (MAX) using Encryption method "code-based" and not encrypt anything; ie is still displayed in simple plain text. Even change the data type to nvarchar (MAX) and still the same. Finally I tried to change in encryption method to "database-based" and neither encrypted.
The same project've had in mysql and it works.
After reviewing the manual PHPRunner the item to encrypt data, I wonder now.
What type of field should be appropriate to encrypt properly in sql server? or you maybe a specific procedure to be performed.
Waiting for your comments.
Yours Faithfully,
Admin 3/17/2015

I'm afraid you doing something wrong. Both varchar (MAX) and nvarchar (MAX) should work and nothing special is required. Unfortunately it's not possible to tell what exactly might be wrong without seeing your project and database.
pasquito author 3/17/2015

Good Night
I tried with Encryption method "code-based" for the table "users" and "password" field as varchar (MAX). From PHPRunner I added a user in the "Admin" group normally; Table reviewing the encrypted password field is displayed.
After starting the login web application, never enters the application; always display the message "invalid connection".
Some more details of the project:

-------------------------------------------

The collation of the database is: Modern_Spanish_CI_AS
In PHPRunner in the "output code page" option is in: Unicode (UTF-8)

I have also tried to Europeo occidental (windows)..
That is what might be happening ?.
Waiting for your comments.
Yours Faithfully,
Admin 3/17/2015

If you need help with this post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program.