| Unexpected Problem with MySQL Query in Linux | Database Management Systems | Computer Science and Engineering Forum | Computer Science Forum|Computer Science and Engineering Forum|Forums|TekTips

Computer Science and Engineering Forum Database Management Systems | Unexpected Problem with MySQL Query in Linux

Unexpected Problem with MySQL Query in Linux

Posted Date Unknown Tom Thomas 2 Comments

Hi All,

Please the query below especially the two table names..

string strSelectQuery = "SELECT MAX(MsgID) AS MsgID FROM FRM_Message_TB ";

string strSelectQuery = "SELECT MAX(MsgID) AS MsgID FROM FRM_MESSAGE_TB ";

The last one executed correctly in Linux MySQL and the First one didn't executed correctly in Linux. In fact it thrown an Exception and I have to pay a big price for this because of its after effects (All messages got deleted because of MsgID Returning -1 in program).

Any idea why the tables are case sensitive in Linux MySQL but not in Windows MySQL?

Tom

See All Responses Below...

Author

Message Rating

borja

Posted on: 02/08/2012

Report Spam

Hi Tom,

This is due to the own OS storage system. So, case sensitive is extensible to the OS that manages the DBMS. This means that in Windows tables and databases are not case sensitive while in Linux they are.

MySQL provides a system variable lowe_case_table_names that affects how MySQL manages case sensitivity. You can get more info at:

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

thomas_tom99

Posted on: 02/08/2012

Report Spam

Hi Borja,

Thanks for the information. But it is really surprising that the SQL Standard didnt take care of this aspect as it might end up in big problems when we create cross platform SQL query ..

Tom

Share this page across other social networking sites

Please Login to Post Your Comments

Name (Max. 100 characters)

Select Language

Comments

Design

HTML

Attach File(Max. Size: 2 MB)

A few simple rules when posting your Comments,

Please post only answers relevant to the topic of discussion.
Please dont misuse this site or do not be abusive, offensive, inappropriate,harass anyone on the boards or post ads or spam. Doing so will delete your inappropriate messages and will block or delete your account on this site.

Related Threads

How to open SQLlite Database in php

How to open SQLlite Database in raspberry pi

How to open SQLlite Database

MSSQL ODBC Drver for 32 bit Linux OS

Oracle ODBC Connection string in Linux clint

Install Oracle Client on Latest Fedora

Data exchange Between 2 sql Servers

DataBase Open Limit In Access

Reset Forgot Paswword of MySQL IN Fedora 16