Sometimes capitalized column name will be converted to lower case in MySQL windows?

Like accountId -> accountid

Has anyone met this kind of proble开发者_Go百科m?

It doesn't happen every day,though.

---

The capitalization is a configuration option, which is enabled by default on windows (and disabled on linux). From the docs:

Consequently, the case sensitivity of the underlying operating system plays a part in the case sensitivity of database and table names. This means database and table names are not case sensitive in Windows, and case sensitive in most varieties of Unix.

---

what do have when you run SHOW VARIABLES

http://dev.mysql.com/doc/refman/5.1/en/show-variables.html?

e.g. lower_case_table_names?