[TYPO3-english] Indexed search and UTF-8

[Jan Loderhose]

Hi,

according to your explanation you have a quite complex situation of
wrong encoded special characters of the danish language. I often see the
same with german umlauts.

Try the following:

1. import the db dump you hopefully created prior to changing the
collation of db fields containing texts

2. set textfield datatypes to binary types
  varchar -> varbinary
  text -> blob
  tinytext -> tinyblob
  and so on and so forth

3. convert these fields a second time. this time reverse the selection
of the datatype (varbinary -> varchar etc.) and select the desired
unicode collation in an atomic step, meaning at the same time.

this is by far the solution to encodingproblems after a switch to utf-8.

good luck!


Am 24.05.2011 02:13, schrieb ktt:
> Hello,
> 
> After conversion of a database to utf-8 collation utf8_general_ci, Indexed search behaviour become quite strange:
> with
> ------------------------------
> config.renderCharset = utf-8
> config.metaCharset = utf-8
> config.sys_language_uid = 0
> config.language = dk
> config.locale_all = dk_DK
> ------------------------------
> it doesn't find a word which contains characters "æ,å.." etc.
> 
> With 
> ------------------------------
> config.renderCharset = utf-8
> config.metaCharset = iso-8859-1
> config.sys_language_uid = 0
> config.language = dk
> config.locale_all = dk_DK
> ------------------------------
> Indexed search splits/converts a search word "ansættelse" and writes:
> 'Search for "ansã" and "ttelse""'
> 
> And searches only for a "ttelse"..
> 
> Indexed search version - 2.12.0
> TYPO3 - 4.5.2
> MySQL client version: 5.0.51a
> 
> Localconf.php UTF-8 settings:
> $TYPO3_CONF_VARS['SYS']['setDBinit'] = 'SET NAMES utf8;
> $TYPO3_CONF_VARS['BE']['forceCharset'] = 'utf-8';
> 
> Could you advise what needs to be changed?
> Since everywhere on the site encodings working correctly except
> that strange word split in Indexed search.
> 
> Thank you in advance,
> Kast A.


-- 
Projektmanager Internet und eCommerce
Senior TYPO3-Integrator
Senior SEO Engineer

https://www.xing.com/profile/Jan_Loderhose

artif orange GmbH & Co. KG
werbung . internet . it . beratung

Am Lorettoplatz  Tel: +49 7071 79527-0
Gölzstrasse 17  Fax: +49 7071 79527-29
72072 Tübingen  http://www.artif-orange.de

Geschäftsführer: Matthias Betz u. Andreas Brus
Amtsgericht Stuttgart HRA 381480
USt-IdNr.: DE240919366

persönlich haftende Gesellschafterin:
Betz & Kögel Verwaltungs GmbH
Amtsgericht Stuttgart HRB 382647
Sitz der Gesellschaft: Tübingen