MySQL table names forced to lower-case, and table_exists function case-sensitive ? |
[eluser]aidehua[/eluser]
Thanks for the tip-off jmadsen & flaky. I had thought/hoped that I was covering myself by using the "COLLATE utf8_unicode_ci" statement, on the basis that the "_ci" part makes the database case-insensitive (irrespective of OS). But I guess that the fact that $this->db->table_exists(‘tbusers’) returns TRUE, but $this->db->table_exists(‘tbUsers’) returns FALSE. shows I was wrong about that... Since I'm stuck (for the time being at least) with developing on a Windows system, but deploying on a Linux server, what do you suggest? Is it time to abandon my taste for CamelCase, and stick to all_lower_case for table names? UPDATE: Quote from http://dev.mysql.com/doc/refman/5.0/en/i...ivity.html: "This means database and table names are not case sensitive in Windows" Since I'm working in Windows, this leaves me quite surprised that $this->db->table_exists(‘tbusers’) returns TRUE, but $this->db->table_exists(‘tbUsers’) returns FALSE. Any comments? |
Messages In This Thread |
MySQL table names forced to lower-case, and table_exists function case-sensitive ? - by El Forum - 01-06-2010, 01:38 PM
MySQL table names forced to lower-case, and table_exists function case-sensitive ? - by El Forum - 01-07-2010, 02:00 AM
MySQL table names forced to lower-case, and table_exists function case-sensitive ? - by El Forum - 01-07-2010, 02:04 AM
MySQL table names forced to lower-case, and table_exists function case-sensitive ? - by El Forum - 01-07-2010, 02:12 AM
MySQL table names forced to lower-case, and table_exists function case-sensitive ? - by El Forum - 01-07-2010, 02:15 AM
MySQL table names forced to lower-case, and table_exists function case-sensitive ? - by El Forum - 01-07-2010, 04:04 AM
|