hello, i have this table in UTF8 (collation is utf8_bin in case it matters). I need to search in it for strings using LIKE '%$searchstring%' . Right now you have to use the exact case in order for the results to show up. Is there a way to make it case insensitive ? Thank you UPDATE sorry, found the answer. ...
The == is used to compare two string in shell script, however I want to compare two strings by ignoring case, how it can be done.Do we any standard command for this. ...
I'm trying to scrape META keywords and description tags from arbitrary websites. I obviusly have no control over said website, so have to take what I'm given. They have a variety of casings for the tag and attributes, which means I need to work case-insensitively. I can't believe that the lxml authors are as stubborn as to insist on full...
Given that (at least on NTFS) the filesystem on Windows is case insensitive, I would like to compare String fileA to String fileB as such: fileA.Equals(fileB, StringComparison.CurrentCultureIgnoreCase) The question then becomes which culture I should use, does the default current (ui?) culture suffice? I can't seem to find any BCL met...
I'm trying to evaluate different strategies for case insensitive UTF-8 string comparison. I've read some material from the Unicode consortium, experimented with ICU and tried to come up with various quality-of-implementation alternatives. On multiple occasions I've seen texts differ between Simple Case Mapping and Full Case Mapping, an...
I have written the following code to do case insensitive replace in C#: Regex.Replace(textBoxText, Regex.Escape(findText), replaceText, RegexOptions.IgnoreCase); Just wanted to check, whether this is the right approach, or is there a better approach and whether I'm overlooking something that I should better be aware of....
I need is_dir() to don't care about if the folder or the argument is upper or lower case, or a mix of upper and lower. So if the foldername is "My Folder" and I run is_dir("mY FoLdEr") the result should be true. ...
Example: > db.stuff.save({"foo":"bar"}); > db.stuff.find({"foo":"bar"}).count(); 1 > db.stuff.find({"foo":"BAR"}).count(); 0 ...
I'm developing an app in Rails on OS X using PostgreSQL 8.4. I need to setup the database for the app so that standard text queries are case-insensitive. For example: SELECT * FROM documents WHERE title = 'incredible document' should return the same result as: SELECT * FROM documents WHERE title = 'Incredible Document' Just...
CheckSpelling On RewriteEngine on RewriteCond %{HTTP_HOST} ^([^.]+)\.site\.com$ RewriteCond /home/%1/ -d RewriteRule ^(.+) %{HTTP_HOST}$1 RewriteRule ^([^.]+)\.site\.com/media/(.*) /home/$1/data/media/$2 RewriteRu...
Hi all, I found in this article, that since ORACLE 10g, there is a way to make a particular connection-session compare strings case-insensitive, without needing any crazy SQL functions, using an ALTER SESSION. Does anyone know if, in 11g, there might be a way to make the database to always operate in this mode by default for all new co...
What't the syntax for performing a case-insensitive match on a 'uid' attribute? If attribute definition matters then how would that be changed? In particular I am using ApacheDS for my LDAP store. ...
I need to make accessing directories on my server case insensitive. How do I do that using htaccess? ...
Hi all, I'm looking for a MySQL collation for UTF8 which is case insensitive and distinguishes between "a" and "ä" (or more generally, between umlauted / accented characters and their "pure" form). utf8_general_ci does the former, utf8_bin the latter, bot none does both. If there is no such collation, what can I do to get as close as po...
How can I create a copy of a string field in case insensitive form? I want to use the typical "string" type and a case insensitive type. The types are defined like so: <fieldType name="string" class="solr.StrField" sortMissingLast="true" omitNorms="true" /> <!-- A Case insensitive version of string type --> <fiel...
I like mysqlimport, its fast and relatively easy to use (much faster then say, PHP or Python front-ends for importing > 20GB data files). However I'd like to do the following. I have a data file that looks like: cat dog 7 Cat Dog 3 CaT DOG 1 with the fields as varchar, varchar, int And I would like the final result to be stored as ['...
Hi, I'm using the The excellent UNIX 'comm' command line utility in an application which I developed on a BSD platform (OSX). When I deployed to my Linux production server I found out that sadly, Ubuntu Linux's 'comm' utility does not take the -i flag to indicate that the lines should be compared case-insensitive. Apparently the POSIX s...
How do I match a case insensitive regex and delete it at the same time I read that to get case insensitive matches, use the flag "i" sed -e "/pattern/replace/i" filepath and to delete use d sed -e "/pattern/d" filepath I've also read that I could combine multiple flags like 2iw I'd like to know if sed could combine both i and d I've t...
The classic way to query an SQL database case-insensitively from Java is as follows: String name = ...; // get the user's input (case is unknown) String sql = "select * from Person where lower(name) = ?"; Object jdbcBindVariable = name.toLowerCase(); // ... using JDBC, bind that variable and run the SQL query The problem is that lowe...
I'm trying to use "contains" case insensitively. I tried using the solution at the following stackoverflow question, but it didn't work: http://stackoverflow.com/questions/187537/is-there-a-case-insensitive-jquery-contains-selector/187557#187557 For convenience, the solution is copied here: jQuery.extend( jQuery.expr[':'], { ...