[TYPO3] UTF8 in MySQL Database with a MySQL client in latin1

[Xavier Perseguers]

Hi Dominique,

Dominique Feyer wrote:
> Hi everybody, here's my summer trouble, if somebody can help me ... i 
> can send some free beer ;-)
> 
> I have a TYPO3 installation setup in UTF-8, like that:
> 
> $TYPO3_CONF_VARS['SYS']['t3lib_cs_convMethod'] = 'iconv';
> $TYPO3_CONF_VARS['SYS']['t3lib_cs_utils'] = 'iconv';
> $TYPO3_CONF_VARS['BE']['forceCharset'] = 'utf-8';
> 
> Is the TS template
> 
> config.renderCharset = utf-8
> 
> But i forgot to set in localconf.php the line:
> 
> $TYPO3_CONF_VARS['SYS']['setDBinit'] = 'SET NAMES utf8;';
> 
> [...]
> 
> So my 2 cents question, is how can I translate/convert this DB to have a 
> standard UTF-8 configuration.
> 
> I have a lots of data inside the database so a manual edition is not 
> possible

Give it a try:
http://xavier.perseguers.ch/en/tutorials/typo3/configuration/utf-8.html

-- 
Xavier Perseguers
http://xavier.perseguers.ch/en