linux - MySql: How to set my.cnf to accept both uppercase and lowercase tables -


how setup mysql my.cnf accept both uppercase , lowercase tables.

environment:
os: ubuntu 14.04 tls
mysql server:
app server: wlserver 12.2.1 (only uppercase tables accepted)
plesk: 12.0.8 (only lowercase tables accepted)

i try

lower_case_table_names=2 #(default value '0') 

error message:

database.table   doesn't exist 

if use

lower_case_table_names=1 

the wlserver work fine wiki, plesk .... have problems

how deal issue?


Comments

Popular posts from this blog

Capture and play voice with Asterisk ARI -

java - Why database contraints in HSQLDB are only checked during a commit when using transactions in Hibernate? -

visual studio - Installing Packages through Nuget - "Central Directory corrupt" -