Encryption: Need to have fixed encrypted value assigned

  • Hi there, not sure if this is possible. Currently, I'm applying encryption on 3 columns in a table and populating the result to another table. The details from this table are then put out to a flat file and uploaded to an analytics system for analysis. The problem with this is whilst the encryption satisfied the requirement to have the unique field, it fails to keep the same encrypted value with respect to another value in another column. See below, I hope I'm able to explain this properly;

    Account Number                   Account Name

    1112223334                            Jason

    1112223335                            Jack

    1112223336                            Jason

     

    From the example above with the two columns, when I employ encryption, it puts out different/unique encryption values for the Account Name column even if their plaintext form is the same (which is how the algorithm was designed to behave), however, I've got a requirement for that to not be the case. They want the same encryption value to be generated for Jason.

    Any ideas around this will be appreciated

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply