[TYPO3-english] set

[Kay Strobach]

Hi Andi,

with 4.5 the default internal character set in TYPO3 ist UTF8 (see
release notes ;).

Please inspect your Tables with e.g. PHPMyadmin:

1. see if they are in latin1
2.  - if 1 yes and phpmyadmin shows correct umlauts
        -> problem (tables need to be converted to utf8)
    - if 1 yes and table shows utf8 placeholderchars ok (repair your
        tables -> see ml archives)
    - if 1 = utf8 and correct umlauts perfect
    - if 1 = other -> set your charset properly ...

Hope that helps.

Regards
Kay

Am 07.08.2011 11:06, schrieb Andreas Becker:
> Hi all
> 
> we have a strange behaviour in one site which we cannot explain.
> 
> We have updated a 4.3 site to 4.5.4
> 
> When we ran the install tool it writes the following two lines into
> localconf.php
> 
> $TYPO3_CONF_VARS['SYS']['setDBinit'] = ''; //  Modified or inserted by TYPO3
>> Install Tool.
>> $TYPO3_CONF_VARS['BE']['forceCharset'] = ''; //  Modified or inserted by
>> TYPO3 Install Tool.
> 
> 
> The my.cnf settings are as follow:
> 
> [client]
>>
> 
> 
>> [mysqld_safe]
>>
> 
> 
>> [mysqld]
>> init_connect='SET collation_connection = utf8_general_ci; SET NAMES utf8;'
>> default-character-set=utf8
>> character-set-server=utf8
>> collation-server=utf8_general_ci
> 
> 
> in php.ini
> 
> default_charset = "utf-8"
>> extension=php_mbstring.so
>> mbstring.internal_encoding = UTF-8
> 
> 
> In apache2.conf
> 
> AddDefaultCharset utf-8
> 
> 
> If we now check the settings in TYPO3 Backend with
> 
>> sm_charsethelper
> 
> 
> everything is green bu the encoding in backend and frontend shows strange
> characters.
> 
> Disabeling those two lines which have been written by the install tool
> instead brings a good output in frontend and backend
> 
> //$TYPO3_CONF_VARS['SYS']['setDBinit'] = ''; //  Modified or inserted by
>> TYPO3 Install Tool.
>> //$TYPO3_CONF_VARS['BE']['forceCharset'] = ''; //  Modified or inserted by
>> TYPO3 Install Tool.
> 
> 
> ======================
> 
> If we delete the line
> 
>> [mysqld]
>> init_connect='SET collation_connection = utf8_general_ci; SET NAMES utf8;'
> 
> 
> the sm_charsethelper shows yellow error warnings because of wrong encoding
> settings with latin_swedish1
> 
> Any idea what might be wrong or how we could check what is wrong beside
> using sm_charsethelper?
> Is there another place where i.e. setDBinit and forceCharset gets defined
> beside localconf.php and that there are wrong settings?
> 
> Andi


-- 
http://www.kay-strobach.de - Open Source Rocks

TYPO3 .... inspiring people to share!
Get involved: http://typo3.org

Answere was usefull: https://flattr.com/profile/kaystrobach