[TYPO3-ttnews] sql error in updating to tt_news 3.1.0

Simon Child simon at srchild.com
Mon Dec 26 20:16:26 CET 2011


"Jigal van Hemert" <jigal at xs4all.nl> wrote in message 
news:mailman.1.1324899082.22465.typo3-project-tt-news at lists.typo3.org...

> The best solution is to move to utf-8 tables and set multiplyDBfieldSize 
> to 1. Working around this may work for some issues, but it might cause 
> another problem when you least expect it.

> I've made a PHP script to convert utf-8 encoded data in latin1 tables [1]. 
> There is also a little script that tries to detect problems in a database 
> [2].

> [1] 
> http://wiki.typo3.org/UTF-8_support#Convert_an_already_existing_database_to_UTF-8
> [2] http://dcbjht.home.xs4all.nl/typo3/db_utf8_test.zip

Thanks, have run your script and all seems well now :)

Season's greetings!

-- 
Simon Child





More information about the TYPO3-project-tt-news mailing list