Project

General

Profile

Actions

Bug #77644

closed

MySQL driver extension breaks searches with hyphens

Added by Christian Rieke about 8 years ago. Updated about 2 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Indexed Search
Target version:
-
Start date:
2016-08-25
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
6.2
PHP Version:
Tags:
Complexity:
Is Regression:
No
Sprint Focus:

Description

If the MySQL driver extension is used, search phrases with a hyphen such as "eq-5d" will return "no results". This occurs quite often in German language sites, but also when searching for dates ("2016-25-08") or medical abbreviations (above).

The problem is probably due to the fact that MySQL itself does not handle full text searches with hyphens very well. One solution seems to be to use full text search IN BOOLEAN MODE. But that, in turn, would break relevance sorting.
My current workaround is to not use the MySQL driver at all.


Related issues 1 (0 open1 closed)

Related to TYPO3 Core - Bug #80292: Indexed search does not respect hyphens in search stringClosed2017-03-15

Actions
Actions

Also available in: Atom PDF