TeddyKiller Posted March 20, 2010 Share Posted March 20, 2010 Title is self explanatry. Some people insert data into a database with whatever values the "user" is inserting. eg: My, my Should the database always consist of strtolower for all values? Also, should the database tables, and names be in lowercase too? Whats the difference to using lowercase or highercase. Quote Link to comment https://forums.phpfreaks.com/topic/195929-what-is-best-in-a-mysql-database-capitals-or-lower-letters/ Share on other sites More sharing options...
jskywalker Posted March 20, 2010 Share Posted March 20, 2010 The data in your tables is a choice the designer of the database should pick. It would for example be SMART to store usernames (and password) case sensitive. Just like the user entered them. That way you can have a user "TeddyKiller", "TEDDYKILLER", "teddykiller", etc which are all different users... If you dont want that to happen, you should make a choice to store them upper- or lowercase. I think the same is true for database tables and fieldnames, make a choice, and stay with it Quote Link to comment https://forums.phpfreaks.com/topic/195929-what-is-best-in-a-mysql-database-capitals-or-lower-letters/#findComment-1029201 Share on other sites More sharing options...
fenway Posted March 20, 2010 Share Posted March 20, 2010 Don't muck around with user data, unless there are strict and tangible formatting requirements. Quote Link to comment https://forums.phpfreaks.com/topic/195929-what-is-best-in-a-mysql-database-capitals-or-lower-letters/#findComment-1029302 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.