Change MySql Case sensitivity with phpMyAdmin?

c# .net mysql blogengine.net
runxc1 Bret Ferrier picture runxc1 Bret Ferrier · Jun 2, 2009 · Viewed 14.4k times · Source

I am running Blogengine.Net and have noticed that the tables are all created lower case (table name be_settings) but a lot of the queries are written mixedcase (Select * from be_Settings). This works fine if your MySql instance is running on Windows or set for capatability with Windows. I am getting an error as my hosting provider MySql instance is case sensitive. Is there a setting I can change to fix this error through phpMyAdmin? I don't want to have to fish through all of the code and fix BlogEngine.Net if I don't have to.

Answer

Chris Henry picture Chris Henry · Jun 2, 2009

Case sensitivity in MySQL table names is specific to the OS. MySQL data is stored in files, which are subject to whatever rules the OS enforces. Linux IS case-sensitive, for example.

There is a variable 'lower_case_table_names' that can be manipulated, but it seems like you'd have to recreate all your tables.

http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html

Related questions

Convert DateTime for MySQL using C#

I want to change the DateTime for MySQL in C#. My MySQL database only accept this format 1976-04-09 22:10:00. In C# have a string who have a date value: string str = "12-Apr-1976 22:10"; I want to convert for MySQL then it …

Read More
Get affected rows on ExecuteNonQuery

I am currently working on a C# project and I am running an insert query which also does a select at the same time, e.g.: INSERT INTO table (SELECT * FROM table WHERE column=date) Is there a way I …

Read More
ASP.NET use SqlConnection connect MySQL

This is the connection string saved in web.config: <appSettings> <add key="conn" value="Driver={MySQL ODBC 5.1 Driver};server=127.0.0.1;uid=root;pwd=1234;database=gis_server;option=3"/> </appSettings> This is the code to connect to …

Read More