Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[BUG] Search not working properly using case-sensitive DBMS #6109

Closed
artggd opened this issue Nov 30, 2016 · 2 comments
Closed

[BUG] Search not working properly using case-sensitive DBMS #6109

artggd opened this issue Nov 30, 2016 · 2 comments

Comments

@artggd
Copy link
Contributor

artggd commented Nov 30, 2016

I am using PostgreSQL - searching content doesn't work properly due to Postgres' LIKE operator being case-sensitive unlike most database systems. This is also true for SQLite.

As per this comment, Doctrine chose to let the platform decide how to manage their case sensitivity, this is why I'm opening this ticket on bolt and not on doctrine's repository.

I suggest to change the query and lower the searched fields and the input string with the LOWER() function. That would cover any database system.

Details

  • Relevant Bolt Version: 3.2.1
  • Install type: Composer install
  • PHP version: 7.0
  • DBMS: PostgreSQL

PR is coming
@bobdenotter
Copy link
Member

PR is coming

Excellent! 👍

@artggd artggd mentioned this issue Nov 30, 2016
Merged
bobdenotter added a commit that referenced this issue Dec 4, 2016
@bobdenotter
Merge pull request #6110 from artggd/case-insensitive-search
ddbd506 
Fixes #6109 - Make content search case insensitive on every platform
@bobdenotter
Copy link
Member

Fixed in #6110

@RicardoEPRodrigues RicardoEPRodrigues mentioned this issue Jun 28, 2021
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@bobdenotter @artggd