[TYPO3-english] Accent insentive on INDEXED SEARCH

[Richard Davies]

Hi,

Whenever a database is changed from e.g. latin to UTF-8 the data needs
to be transformed. What I've done is mysqldump --char-set=UTF8 and
then mysql --char-set=UTF8 > sql.sql. Switching database type without
changing the data inside generally doesn't work. If you've done that,
is your site outputting the correct meta tag?

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

The database may not be entirely UTF8 or connection may not be UTF8.
Check out this: http://wiki.typo3.org/wiki/UTF-8_support


On 14 December 2011 06:59, Javier Moñiz <javiermoniz at gmail.com> wrote:
>
> The search at my web doesn't find the same number of results when i
> search a phrase with french accents , for example a research for the
> word methodes , gives back one result, but if i search for the word
> méthodes i get back 26 results.
> My database was forcely set from latinswidish to utg8_general_ci and
> also the fields at the table.
> I´ve tried to force UTF8 from instalation panel
> ([BE][forceCharset])but as i do this i get weird square caracters at
> the website , all the rest is peacefully set at utf8 with no problems.
> I obviusly had to unset the [BE][forceCharset] on utf-8.
>
> I am close to desperate with no more ideas on mind. If someone has
> gone through this inferno i would apreciate a word from. Any help or
> idea is welcome.
> Thanks
> _______________________________________________
> TYPO3-english mailing list
> TYPO3-english at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english