What is the best practice for storing text data?
I've been building a complex system for months and I have a number of people that use the system. I currently have text such as names and addresses using Title Case formatting but I'm realizing that there is room for error with names such as McDougal and such. Then I started looking at how other databases handle this and usually, all data is UPPERCASE. I'm looking at converting all the data and every input field to store the data as UPPERCASE then allowing me the ability to convert it to anything else later. Is this good practice for programming or am I just asking for a headache? What is the best procedure to do this?