Benjamin Krajmalnik
|
| Posted: 04/11/2006, 11:47 AM |
|
Unlike MS SQL Server and many other databases whose default mode is for
searches to be case insensitive, PotgreSQL always uses a case sensitive
search.
In a purist sense, the PostgreSQL team is correct. We can debate all day on
whether this is the correct way of doing this or not <vbg>, but more
important is to have a solution, since mosy of us would like our "contains",
etc. searches to be case insensitive.
To address this, PostgreSQL has extended the syntax to include an operator
called "ILIKE". TO make all PostgreSQL searches case insensitive, you need
to modify your classes common file (Classes.php, Classes.ASP, etc.) and
change the occurrences of "like" with "ilike".
The other solution is a more complex one, since it would not fit as well
within the framework, since it would require using expressions in the query
editor.
|
|
|
 |
|
