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. 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 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. 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
Archived
This topic is now archived and is closed to further replies.