Code

Opened 7 years ago

Closed 7 years ago

#5575 closed (invalid)

ILIKE not supported by MySQL

Reported by: sagi@… Owned by: nobody
Component: Documentation Version: master
Severity: Keywords: ILIKE icontains
Cc: Triage Stage: Unreviewed
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: UI/UX:

Description

You mention that Sqlite3 does not support ILIKE but it seems that MySQL doesn't either. You probably want to point this out since icontains won't work as expected

Attachments (0)

Change History (1)

comment:1 Changed 7 years ago by mattmcc

  • Needs documentation unset
  • Needs tests unset
  • Patch needs improvement unset
  • Resolution set to invalid
  • Status changed from new to closed

By default, MySQL searches are not case sensitive. http://dev.mysql.com/doc/refman/5.0/en/case-sensitivity.html

Also possibly related, #2170.

Add Comment

Modify Ticket

Change Properties
<Author field>
Action
as closed
as The resolution will be set. Next status will be 'closed'
The resolution will be deleted. Next status will be 'new'
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.