Project

General

Profile

Actions

Bug #19195

closed

Indexed search saves characters in word table with different encoding than in content table

Added by Sacha Vorbeck over 15 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Should have
Category:
Indexed Search
Target version:
-
Start date:
2008-08-05
Due date:
% Done:

0%

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

Description

I added the line
$TYPO3_CONF_VARS['SYS']['setDBinit'] = 'SET NAMES utf8;';
to the localconf.php and all chars are no written to the DB correctly.

When using the info-module: "INFO->Indexed Search->Words and content", I can see that in the content-column german umlauts and other special chars are displayed correctly. But in the words column the umlauts are cryptic.
e.g.: aboanträge vs. aboanträge

The same goes for looking at the index_words table with phpmyadmin. In all other tables (tt_content, pages...) the chars are displayed correctly.

So it seems that indexed search uses a different way to create the DB-entries in the word table than it does for the content.

I also noted that the cb_indexedsearch_autocomplete extension doesn`t display the umlauts correctly but I`m not sure if that`s a problem with the extension are also relates to the encoding in the words table.

TYPO3 4.2.1 installation with
indexed_search 2.11.0 and
cb_indexedsearch_autocomplete 0.3.0
(issue imported from #M9125)

Actions

Also available in: Atom PDF