[TYPO3-dev] how to set the charset correctly to UTF-8

Franz Holzinger franz at ttproducts.de
Wed Jan 4 21:00:19 CET 2012


Hello,

I have a problem on one site.
I have successfully executed the script
http://wiki.typo3.org/UTF-8_support#Convert_an_already_existing_database_to_UTF-8 

by Jigal van Hemert.
All characters are shown correctly with phpMyAdmin. The database, the 
tables and the tables fields are all set to 'utf8_general_ci'.
php.ini:
default_charset = "utf-8"

TYPO3 4.6.3
PHP 5.3.2
mysql  Ver 14.14 Distrib 5.1.41

[BE][forceCharset] =



Now I have two cases:

1. setDBinit is empty.

2. setDBinit is set to
SET NAMES utf8;

---

1.)
Backend texts are wrong.
TCE:
f�r instead of für
K�ln instead of Köln

The page tree shows empty texts for each page with a title which 
contains an umlaut,

Frontend is ok.

2.)
Backend is ok.

Frontend is wrong:
Ãœberblick instead of Überblick
Köln instead of Köln


How can I solve this dilemma? Both TYPO3 Backend and Frontend shall show 
the correct UTF-8 characters.

- Franz




More information about the TYPO3-dev mailing list