[TYPO3] utf-8 problem
mr at onscreen.at
Mon Jul 3 15:08:28 CEST 2006
The following helped:
1) changing all tables and all varchar/char/text columns to utf8
2) using the following wiki-help
TYPO3 Install Tool Options
[setDBinit] String (textarea): Commands to send to database right after
connecting, separated by newline. Ignored by the DBAL extension except
for the 'native' type!
SET CHARACTER SET utf8
SET NAMES utf8
SET SESSION character_set_server=utf8
Martin Kutschker schrieb:
> Markus Rathmayr schrieb:
>> i have to do an import of a product list into typo3. I'd like to do
>> with phpmyadmin via text files. the problem ist that the special
>> characters in the various languages are either wrong in typo3 surface
>> or in the phpmyadmin surface but both are configured to use utf-8.
>> does anyone have an idea how to import textfiles into mysql via
>> phpmyadmin with utf-8 encoding without losing the special characters
>> in typo3?
> I always struggle with phpMyAdmin and charsets. It either does a
> conversion when I don't want it or vice versa. So I ususally convert the
> dump via iconv or recode on the console. And I think that newer Mysql
> server can do the conversion automaitcally given the correct CLI
> arguments and/or infos in the dump file (see Mysql docs).
More information about the TYPO3-english