[TYPO3-english] problem with charset / DB

[Kay Strobach]

Hello Goerg,

write a small script (e.g. in PHP) which runs over all Tables and all
textfields in them and read out the data.
Use the php functions of mb_string or other charset helpers to force
your needed charset -> anyway i suggest you to switch to UTF8.

Test the script on a dev server before using it on production env.
Backup you DB.
Run the script.
Check if all is working as expected.

Now you're done ;)

Regards
Kay

Am 27.05.2011 12:01, schrieb Georg Schönweger:
> Hi Gert,
> 
> ok i see so you are upgrading your latin1 DB to real utf-8, right? .. i
> don't want to do this and i can't make a new dump from the old server
> because now the current DB is in use for some time and i can not drop
> all new changes ..
> Any hints how i can check if my DB is ok?
> 
> - Georg
> 
> Am 27.05.2011 11:47, schrieb RDE / Redlich:
>> Georg Schönweger schrieb:
>>
>> Hallo Georg
>>
>> you should dump your database with an option
>>
>> look here (it is German)
>>
>> http://software.rde.de/typo3-6-hilfsprogramme.html
>>
>> goto Line/Element 108 : Dump old Database
>>
>> watch the option --compatible
>>
>> on my servers it did work fine.


-- 
http://www.kay-strobach.de - Open Source Rocks