case-insensitive

php/mysql: how to search case insentitively

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. ...

Case Insensitive comparision of strings in Shell script

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. ...

Is it possible for lxml to work in a case-insensitive manner?

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...

.NET How to compare two Strings that represent filenames ignoring case correctly

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...

Case fold UTF-8 without knowing the language

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...

What are the things to watch out for with case insensitive regex replace?

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....

How to make is_dir($FoLdEr) case insensitive in php?

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. ...

MongoDB: Is it possible to make a case-insensitive query?

Example: > db.stuff.save({"foo":"bar"}); > db.stuff.find({"foo":"bar"}).count(); 1 > db.stuff.find({"foo":"BAR"}).count(); 0 ...

Anyone had success using a specific locale for a PostgreSQL database so that text comparison is case-insensitive?

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...

mod_speling & mod_rewrite to work together?

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...

ORACLE 11g case insensitive by defalt

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...

case insensitive LDAP searches

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. ...

Make Folders in Apache Case Insensitive using .htaccess

I need to make accessing directories on my server case insensitive. How do I do that using htaccess? ...

Looking for case insensitive MySQL collation where "a" != "ä"

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 to create a case insensitive copy of a string field in SOLR?

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...

How to accumulate results using mysqlimport

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 ['...

UNIX 'comm' utility allows for case insensitivity in BSD but not Linux (via -i flag). How can I get it in Linux?

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...

Using sed to delete a case insensitive matched line

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...

What locale should I use for case-insensitive queries from Java?

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...

How do I make jQuery Contains case insensitive?

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[':'], { ...