2. PHPRunner General questions
  3. Encryption Trash = c죸†
This topic is locked

Encryption Trash = c죸†

 		5/17/2011 09:50:03
PHPRunner General questions
N
 nti author

does anyone other then me... have issues with encryption due to trash like: c죸â€
My encryption is for text and numbers. I do not utilize Credit Card Numbers. Just names and phone numbers.
Happens during Add New Record. Also appears on views if fields are empty. I haved tried various methods to correct problem by modifying DB Table Field settings, ex: Null vs Not Null. The fields with the garbage are the encrypted fields.
The fields do not show the garbage during edit or view even if the field is empty.
Now wondering if tinytext is causing the problem? <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=17041&image=1&table=forumtopics' class='bbc_emoticon' alt=':blink:' />
I have read various articles from forum and google and most postings I have read recommends binary and varbinary for encrypted fields.
I have tried binary and it does not decrypt for me. It looks like garbled binary. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=17041&image=2&table=forumtopics' class='bbc_emoticon' alt=':unsure:' />
Hoping for some feedback to help me resolve my encryption problem.
Thank you for all feedback. nti
Sergey Kornilov admin 5/17/2011

I guess you trying to encrypt text that is encrypted already. Its not related to field data type in any way. Check your encryption/decryption logic and make sure you don't encrypt text that is encrypted already.
N
 		nti author 5/18/2011

Thank Sergy for response.
The field is blank and trash is only in field during "add a record" TABLE_add.php process.
I am using the following Field setup options:
tinytext, latin1_swedish_ci, NULL = No, Default = None
I have tried setting Default as Null, and many other options but trash shows up during the add process.
If I add a new record and leave the same fields empty, it does not happen for edit or view or list.
Annoying little issue I'm trying to correct.
All feedback welcomed.
Sergey Kornilov admin 5/18/2011

Unfortunately not sure what else I can without seeing the actual application.