Database and case sensitive
-
Hello everyone, In this second Monday(i hate work days so much) i have a inner fight. Right now i am working on a project who accepts a file with attributes and after few modifications it should insert them into the DB. The database column names are all capital letters. As i develop my part of the project i assumed that the input file can contain attributes with different case than the DB column name and based on that i changed the compare function. But my boss said that when we have constants defined in the project (db column names are defines as constants) there is no way for the input file to contain different casing than the db column names. I disagree on that. I think its better to make a case insensitive compare for the attribute keys no matter the db column names What do you think? Which is the better practice?
Microsoft ... the only place where VARIANT_TRUE != true