[TYPO3] setDBinit

lee perry leeperry at slack.de
Thu Sep 4 18:02:44 CEST 2008


Hi Brian,

if I set my DB inits by using the install-tool by "All Configuration" 
I've got the following statement in the localconf.php:

$TYPO3_CONF_VARS['SYS']['setDBinit'] = 'SET CHARACTER SET 
utf8;'.chr(10).'SET NAMES utf8;'.chr(10).'SET SESSION 
character_set_server=utf8;';

Maybe try this.


Greetings,
Lee

> Can I only set one option in this statement? 
> 
>  
> 
> Works - $TYPO3_CONF_VARS['SYS']['setDBinit'] = 'SET SESSION
> sql_mode=MYSQL40;'
> 
> Works - $TYPO3_CONF_VARS['SYS']['setDBinit'] = 'SET NAMES utf8;';
> 
>  
> 
> Does not work $TYPO3_CONF_VARS['SYS']['setDBinit'] = 'SET SESSION
> sql_mode=MYSQL40; SET NAMES utf8;';
> 
>  
> 
> I tried setting these in the database themselves but that did not help. 
> 


More information about the TYPO3-english mailing list