View Issue Details

WikiJump to Notes
IDProjectCategoryView StatusDate SubmittedLast Update
0011012mantisbtdb postgresqlpublic2009-10-07 08:302014-05-16 15:02
Reportercedric villemain Assigned Todhx  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionduplicate 
Product Version1.2.3 
Target Version1.2.5 
Summary0011012: manage_user_page.php?prefix=C is case sensitive
Description

And my users does not have necessary an upper case first letter. So I wonder why not use a case insensitive search ?

check the patch in 'additionnal information'

Additional Information

manage_user_page.php
197c197
< $t_where = "(username like '$c_prefix%')";

          $t_where = "(upper(username) like '$c_prefix%')";
Tagspatch

Relationships

duplicate of 0012760 closeddhx Manage User page filter is case sensitive for some database backends 
related to 0012145 confirmed Search should do case insensitive lookups 

Activities

dhx

dhx

2011-02-28 05:23

reporter   ~0028315

Fixed in 0012760, thanks for reporting.
grangeway

grangeway

2014-05-16 15:02

reporter   ~0040534

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