Tag: mysql server
Mono .net (dot net) mysql table names issue case sensitive on linux but insensitive on Windows, mono.net fix in my.cnf or my.ini mysql server config file
by Admin on Nov.16, 2010, under Linux Unix Stuff
I had some issues with a .Net webservice that I ported to run on Mono, it kept on giving error that database.Table does not exist….and when i changed the “Table” name in the .cs c# code to reflect a lower case ‘table’ name and renamed the mysql database Table to “table”…it would then still give me an error that database.Table does not exist…anyway, the quick fix was to edit my mysql server config file, could be my.cnf in my case was my.ini or mysql.ini and i added lower_case_table_names=1 depending on mysql server version you might have to use lower_case_sensitive = 1 and put it in your [mysqld] section of your config file. It will then assume all table names as lowercase….under Windows I think that’s the default behaviour anyway since from what I know it doesn’t support case sensitivity….