c# - How to retrieve encrypted data from database irrespective of case? -


i want retrieve encrypted data database sql, irrespective of case inserted in database.i have data in database in encrypted form when retrieve data using different case gives me wrong or no data.

for ex:

i have inserted abc in database salt created value different abc.

now user wants search abc these values same have different salt.abc has different encrypted value,abc has different in database. how can value irrespective of salt created without problem of case sensitive.

i have no option available check case @ time of insertion in database.

note: salt created in application using c#.

is possible,if not is/are options?

should standardize field @ time of insertion toupper() or to lower()?


Comments

Popular posts from this blog

php - Wordpress website dashboard page or post editor content is not showing but front end data is showing properly -

How to get the ip address of VM and use it to configure SSH connection dynamically in Ansible -

javascript - Get parameter of GET request -