[TYPO3-english] Charset encoding problem since 5.3.6

David ARNOULT - Edition & Internet Operations d.arnoult at topsolid.com
Fri Jul 8 15:18:32 CEST 2011


Hi,

Thanks to Ricardo and Dominic for both hints that helped to work it out, it
was nightmare for me.

Despite my concern, it seems that MySQl-TYPO3 connection is in latin1 mode
for all my languages, Chinese included...
character_set_client
latin1
character_set_connection
latin1
character_set_database
utf8
character_set_filesystem
binary
character_set_results
latin1

Converting script did not work for me, for I had to step back to original
config because web site is live.
Config that works:
$TYPO3_CONF_VARS['SYS']['setDBinit'] = 'SET NAMES utf8; [-LINE BREAK-] SET
character_set_connection = utf8';
$TYPO3_CONF_VARS['BE']['forceCharset'] = 'utf-8';

I know it's not clean and not really solved, but it solved my problem in
short term. It wasn't PHP either Apache.

I will convert DB offline on a test web site, when upgrading to 4.5.
Btw anyone knows a good resource/tutorial to convert MySQL DB from latin1 to
utf-8 in my case?

Thank you all!

David
-----Message d'origine-----
De : typo3-english-bounces at lists.typo3.org
[mailto:typo3-english-bounces at lists.typo3.org] De la part de Dominic Garms
Envoyé : vendredi 8 juillet 2011 07:23
À : typo3-english at lists.typo3.org
Objet : Re: [TYPO3-english] Charset encoding problem since 5.3.6

Hi David,

check this out:
http://wiki.typo3.org/wiki/UTF-8_support

In the chapter "convert existing database" there is a small sript 
db_urf8_fix.zip. This script did my trick when I upgraded 4.2.17 
websites to 4.5.3. You also have to make sure that the utf-8 parameter 
are correctly set in your install tool.

Regards,

Dominic

_______________________________________________
TYPO3-english mailing list
TYPO3-english at lists.typo3.org
http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english




More information about the TYPO3-english mailing list