0007817: text search with PostgreSQL is always case sensitive

ID	Project	Category	View Status	Date Submitted	Last Update
0007817	mantisbt	db postgresql	public	2007-03-12 14:38	2014-05-16 15:02

Reporter	olegos	Assigned To	vboctor
Priority	normal	Severity	minor	Reproducibility	always
Status	closed	Resolution	fixed
Product Version	1.0.6
Fixed in Version	1.1.0a3

Summary	0007817: text search with PostgreSQL is always case sensitive
Description	The text search in filter is always case sensitive when using PostgreSQL. Should be text insensitive (as it is with MySQL).
Additional Information	This is because LIKE in PostgreSQL is text sensitive, but there is ILIKE which does the same but case insensitive. Changing LIKE's to ILIKE's in filter_api.php makes searches case insensitive. From http://www.postgresql.org/docs/8.1/static/functions-matching.html : "The key word ILIKE can be used instead of LIKE to make the match case-insensitive according to the active locale. This is not in the SQL standard but is a PostgreSQL extension."
Tags	No tags attached.

vboctor 2007-03-12 22:43 manager ~0014176	The code was changed to use ILIKE rather than LIKE in case of PostgreSQL. This is done for both free text search and custom fields search.

grangeway 2014-05-16 15:02 reporter ~0040558	MantisBT currently supports Mysql and has support for other database engines. The support for other databases is known to be problematic. Having implemented the current database layer into Mantis 10 years ago, I'm currently working on replacing the current layer. If you are interested in using Mantis with non-mysql databases - for example, Oracle, PGSQL or MSSQL, and would be willing to help out testing the new database layer, please drop me an email at paul@mantisforge.org In the meantime, I'd advise running Mantis with Mysql Only to avoid issues. Thanks Paul