[TYPO3-english] converting to utf-8

[Jigal van Hemert]

Hi,

On 13-10-2011 22:45, Urs Bräm wrote:
> This german tutorial
> http://t3n.de/magazin/mysql-typo3-utf-8-umstellen-tipps-wechsel-latin1-utf-8-220945/
> has worked quite well for me

Which requires a lot of manual work.

[1] contains a script that is pretty good at detecting utf-8 encoded 
data in non-utf-8 database fields. If it finds problems it will show the 
field name(s) with an exclamation mark. If it just lists table names 
with 'OK' then no problems are found.

[2] (as mentioned by Katja) is a script to automagically repair this. It 
is a potentially dangerous operation, so the script is normally in 
simulation mode (see start of script) and a backup of your database 
should be made first.

Both scripts use mainly MySQL queries to perform the magic.

[1] http://dcbjht.home.xs4all.nl/typo3/db_utf8_test.zip
[2] http://dcbjht.home.xs4all.nl/typo3/db_utf8_fix.zip

-- 
Kind regards / met vriendelijke groet,

Jigal van Hemert.