Defect #18537

Special language characters not treated right in search

Added by elite solutions over 4 years ago. Updated over 4 years ago.

Status:ClosedStart date:
Priority:NormalDue date:
Assignee:Jean-Philippe Lang% Done:

0%

Category:Search engine
Target version:-
Resolution:Wont fix Affected version:1.4.4

Description

Searching a word with german umlaute, results in too many search results. I cannot figured out, what problem it is exactly.


Related issues

Related to Redmine - Defect #18862: troubles in search (Redmine 2.5.2.stable, russian text) New

Associated revisions

Revision 13754
Added by Jean-Philippe Lang over 4 years ago

Don't use #downcase on search tokens, let the database handle it (#18537).

Revision 13757
Added by Jean-Philippe Lang over 4 years ago

Mysql LIKE treats Ö and O the same (#18537).

Revision 13759
Added by Jean-Philippe Lang over 4 years ago

Use custom SQL for MySQL to behave like others DBMS: case-insensitive search without ignoring accentuation (#18537).

Revision 13760
Added by Jean-Philippe Lang over 4 years ago

SQLite does not support case insensitive match for non-ASCII characters (#18537).

Revision 13761
Added by Jean-Philippe Lang over 4 years ago

Missing test helper (#18537).

Revision 13767
Added by Jean-Philippe Lang over 4 years ago

Restore accent insensitive search with mysql (#18537).

History

#1 Updated by Toshi MARUYAMA over 4 years ago

  • Status changed from New to Needs feedback

See Submissions.
1.4.4 is too old.
You should use recent version.

#2 Updated by Jean-Philippe Lang over 4 years ago

  • Status changed from Needs feedback to Closed
  • Assignee set to Jean-Philippe Lang
  • Target version set to 3.0.0
  • Resolution set to Fixed

This should be fixed in 3.0 (r13754).

#3 Updated by Fernando Hartmann over 4 years ago

This means for example that, from now, this two searches strings "café" and "cafe" didn't result on the same response ?
If true it's very bad for us, it will broke our day by day use, my users are used to made the searches ignoring the accentuation, this solves the problem of bad spelling by the issue reporter.
I believe that stuff should be a option in the search like #992

#4 Updated by Jean-Philippe Lang over 4 years ago

  • Target version deleted (3.0.0)
  • Resolution changed from Fixed to Wont fix

I agree, case insensitive search makes more sense generally.

#5 Updated by Toshi MARUYAMA over 4 years ago

  • Related to Defect #18862: troubles in search (Redmine 2.5.2.stable, russian text) added

Also available in: Atom PDF