I don’t think you’ll get a better answer than “because the author(s) of that language thought it was better that way”. Personally, I think they’re right. I’d hate to find these lines anywhere in the same source file (and refer to the same object+method)… SomeObject.SomeMethod(); … SOMEOBJECT.SOMEMETHOD(); … someObject.someMethod(); … sOmEoBjEcT.sOmEmEtHoD(); I don’t think anyone … Read more
By default, Oracle identifiers (table names, column names, etc.) are case-insensitive. You can make them case-sensitive by using quotes around them (eg: SELECT * FROM “My_Table” WHERE “my_field” = 1). SQL keywords (SELECT, WHERE, JOIN, etc.) are always case-insensitive. On the other hand, string comparisons are case-sensitive (eg: WHERE field=’STRING’ will only match columns where … Read more
Yes, it is case sensitive, just like the rest of UNIX. $date and $DATE are two different variables. makefile and Makefile are two different files. -h and -H are two distinct flags (usually).
You can use the UPPER keyword on your case insensitive field then upper-case your like statement. e.g. SELECT * FROM mytable WHERE caseSensitiveField like ‘test%’ AND UPPER(caseInsensitiveField) like ‘G2%’
It depends on the collation of the field – if it’s ci (case insensitive) or cs (case sensitive). The unique index would apply accordingly.
Use grep or git grep in your local clone. The GitHub search has a lot of limitations. I think the worst of these is that it only shows the first two matches from any file, so I just avoid it whenever possible.
Collation can be set at various levels: Server Database Column So you could have a Case Sensitive Column in a Case Insensitive database. I have not yet come across a situation where a business case could be made for case sensitivity of a single column of data, but I suppose there could be. Check Server … Read more
FYK (updated) Case sensitive (both user-defined and PHP defined) variables constants ->>check Amendment 1 array keys class properties class constants Case insensitive (both user defined and PHP defined) functions class constructors class methods keywords and constructs (if, else, null, foreach, echo etc.) In php.net Basics Variables in PHP are represented by a dollar sign followed … Read more
Looks like mysql is case insensitive by default: You probably need to create the column with a case sensitive collation (e.g. utf8_bin): CREATE TABLE WORDS ( ID BIGINT AUTO_INCREMENT, WORD VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL UNIQUE, PRIMARY KEY(ID) );
On Unix, table names are case sensitive. On Windows, they are not. Fun, isn’t it? Kinda like their respective file systems. Do you think it’s a coincidence? In other words, if you are developing on Windows but planning on deploying to a Linux machine, better test your SQL against a Linux-based MySQL too, or be … Read more