[TYPO3-english] Typoscript non-latin characters not saving
dmitry.dulepov at gmail.com
Wed Jul 24 10:59:04 CEST 2013
> Transferring the database
> Your source and target web servers should have the same character set and collation settings. You can view them using mysql command line utility:
> show variables like 'character_set_%';
> show variables like 'collation_%';
> If these settings do not match, my.cnf settings on destination server should be adjusted. If changing my.cnf settings is not possible, you can put adjustments into setDBInit in Install tool. For example, to convert server fully to UTF8 for the current session, do:
> SET NAMES utf8
> SET SESSION character_set_server=utf8
> The first command changes all settings except character_set_server. The second one changes settings for server. If that stays latin1 (not UTF8), most likely you will get weird errors (like "Field was not properly updated in the database") when saving records with non-English characters.
Dmitry Dulepov wrote:
> Jigal van Hemert wrote:
>>> I have the database character set & collation as UTF-8 unicode.
>>> localconf.php has the following
>>> $TYPO3_CONF_VARS['SYS']['setDBinit'] = 'SET NAMES utf8;'.chr(10).'SET
>>> SESSION character_set_server=utf8;';
>> SET NAMES utf8; is enough. This sets all the necessary options to UTF-8.
> Except "character_set_server".
More information about the TYPO3-english