Is MySQL case sensitive?

yooj · #1 (**permalink**) 08-26-2007, 02:37 PM

The title says it all. Is MySQL case sensitive?

**Jordan** · #2 (**permalink**) 08-28-2007, 07:45 AM

I believe it depends on the Operating System you have MySQL on. I could be wrong though:

Quote:

Although database and table names are not case sensitive on some platforms, you should not refer to a given database or table using different cases within the same statement. The following statement would not work because it refers to a table both as my_table and as MY_TABLE:

Code:

mysql> SELECT * FROM my_table WHERE MY_TABLE.col=1;

MySQL AB :: MySQL 5.0 Reference Manual :: 8.2.2 Identifier Case Sensitivity

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Tutorial: PHP to MySQL	Jordan	PHP Tutorials	9	Today 12:12 PM
MYSQL CheatSheet - A must for MySQL Users	reachpradeep	Database & Database Programming	1	03-03-2007 03:05 PM
Toad for MySQL	Lop	Database & Database Programming	0	12-06-2006 11:07 AM
Toad for MySQL 2.0.1	Kernel	Software Development Tools	0	10-03-2006 06:03 AM
MySQL Resources	dirkfirst	Database & Database Programming	1	05-25-2006 02:31 AM

John	........	223.00000
dargueta	........	168.00000
Xav	........	164.00000
LogicKills	........	20.00000
sam	........	20.00000
gaylo565	........	18.00000
\|pH\|	........	15.00000
WingedPanther	........	15.00000
Johnnyboy	........	3.00000
navghost	........	1.00000

CodeCall

Contest Stats

CodeCall Goal

Sponsors

Ads

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)