-
Jul 23rd, 2014, 01:46 PM
#1
Thread Starter
Don't Panic!
Case sensitive in sql statement > MySql db..?
Hi
Just a qustion, probably me being slack due to MS Access allowing non case sensitive matches in sql statements, but weird.
The XAMPP on the machine appears to allow it (ie SELECT * FROM tblUsers or SELECT * FROM tblusers) but the one I'm hosting on (free and just to show other people) wont open the queries unless the tables match exactly.
Is there a setting on MySql that can allow any case sensitive naming..?
Or is it a setting on the PHP Online server (older version I think)..?
Feeling like a fly on the inside of a closed window (Thunk!)
If I post a lot, it is because I am bored at work! ;D Or stuck...
* Anything I post can be only my opinion. Advice etc is up to you to persue...
-
Jul 23rd, 2014, 09:45 PM
#2
Re: Case sensitive in sql statement > MySql db..?
-
Jul 24th, 2014, 02:23 PM
#3
Thread Starter
Don't Panic!
Re: Case sensitive in sql statement > MySql db..?
Ah hmmm maybe.. Windows here... but the server on the free hoster might be unix or linux...
Ok that makes sense.
Thanks
Feeling like a fly on the inside of a closed window (Thunk!)
If I post a lot, it is because I am bored at work! ;D Or stuck...
* Anything I post can be only my opinion. Advice etc is up to you to persue...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|