database-agnostic

Is it crazy to bypass database case sensitivity issues by storing original string case AND lower case?

I'm implementing a database where several tables have string data as candidate keys (eg: username) and will be correspondingly indexed. For these fields I want: Case insensitivity when someone queries the table on those keys The initially written case to be preserved somehow so that the application can present the data to the user wit...

how to allow your code to store undetermined number of columns ?

Hi, I think my question might be unclear , but i would try to explain it by example . say that we had about 100 different car model , clearly all of the car would share common parts or specification but not all parts are shared between all of these 100 car brands what is the best practice of storing these specification in this case...