hassank1 Posted April 2, 2008 Share Posted April 2, 2008 I've tested my website on wamp and everything's was fine .. then I uploaded it to the internet !! however I've noticed that some queries didn't work !! then I figure out that the table name must be exactly as they were written in the db ex : "Table" works and "table" error !! however what I know is sql isn't case sensitive..so is there a solution ? ! I don't want to rename all my queries !! Link to comment https://forums.phpfreaks.com/topic/99280-mysql-is-case-sensitive/ Share on other sites More sharing options...
gluck Posted April 2, 2008 Share Posted April 2, 2008 Unix is case sensitive change lower_case_table_names in my.ini to suit your needs check: http://dev.mysql.com/doc/refman/5.0/en/case-statement.html Link to comment https://forums.phpfreaks.com/topic/99280-mysql-is-case-sensitive/#findComment-507988 Share on other sites More sharing options...
hassank1 Posted April 3, 2008 Author Share Posted April 3, 2008 my.ini ? where I can find this file ?.. could u provide me with more details plz (newb !) Link to comment https://forums.phpfreaks.com/topic/99280-mysql-is-case-sensitive/#findComment-508250 Share on other sites More sharing options...
trq Posted April 3, 2008 Share Posted April 3, 2008 If this is shared hosting you won't have access to the my.ini file. This is the main configuration file for the mysql server. Otherwise, if this is your server, take a look in the /etc/mysql directory. Link to comment https://forums.phpfreaks.com/topic/99280-mysql-is-case-sensitive/#findComment-508256 Share on other sites More sharing options...
PFMaBiSmAd Posted April 3, 2008 Share Posted April 3, 2008 Check section 7.2.2. Identifier Case Sensitivity in the mysql manual on what settings are available. But, the solution is simple, always use lower case identifiers or be consistent and use the exact table name you created. Link to comment https://forums.phpfreaks.com/topic/99280-mysql-is-case-sensitive/#findComment-508466 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.