Archive for the ‘SQL’ Category

Case-Sensitive Calls to SQL

on October 14, 2010 | Filed Under SQL | No Comments »

Storing case-sensitive information in a SQL database can be a bit of a challenge. Traditionally, if you’re going to store information that needs to be retrieved based on the case, you need to encrypt it. But what happens when you are brought in on a project and a data set has been given to you, which has been created over a long period of time? Sure, you can create an application that goes through and encrypts the data, then go through thousands of lines of code, to ensure that every reference to that field is changed to use your encryption method. But maybe that’s not an option.

Read the rest of this entry »