Training, Open Source computer languages
PerlPHPPythonMySQLApache / TomcatTclRubyJavaC and C++LinuxCSS 
Search for:
Home Accessibility Courses Diary The Mouth Forum Resources Site Map About Us Contact
 
Python, Lua and Tcl - public course schedule [here]
Private courses on your site - see [here]
Please ask about maintenance training for Perl, PHP, Java, C, C++, Ruby, MySQL and Linux / Tomcat systems

Phone System reconfiguration 11.1.2018 to 26.1.2018 - we are on email but incoming landline not available. Temp number 0797 4 925928
 
MySQL as Case Sensitive

Posted by keith (keith), 9 December 2004
Hi all... especially Graham
(Graham :- Courses in September on MySQL and PHP)

I am confused and need help.

How do I make MySQL case sensitive when I query it in PHP?

Currently if I say .....WHERE abcd='A'

It finds both a and A entries.

Posted by admin (Graham Ellis), 9 December 2004
In MySQL, queries are case sensitive if a field is defined as being a binary field, and are case insensitive on non-binary fields.  Sounds like you may need to go back and change your field definitions!

(If you really want to store binary data, bu the way, you  use a blob and not a binary type.)



This page is a thread posted to the opentalk forum at www.opentalk.org.uk and archived here for reference. To jump to the archive index please follow this link.

You can Add a comment or ranking to this page

© WELL HOUSE CONSULTANTS LTD., 2018: Well House Manor • 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
PH: 01144 1225 708225 • FAX: 01144 1225 793803 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho