I need my bank to accept capital letters in table names, for example when I create the table
tbl_ALGUMACOISA
It appears to me
tbl_algumacoisa
This also works with the fields, how should I solve these problems?
Sensitive case MYSQL
0
asked by anonymous 10.07.2016 / 17:31
1 answer
3
In the MySQL configuration file, set the parameter lower_case_table_names with value 2 .
Example:
lower_case_table_names=2
If the parameter does not exist, acidify it.
Make changes, save the file and restart MySQL.
The default settings file
Windows: my.ini
Linux: my.cnf
Location varies by installation.
Highlighting these are the default names. The file name may be different or may be loading a specific file at run time.
Additionally, I recommend reading this post: Table and column nomenclature
10.07.2016 / 17:38