Hello Kay, thank you for your tip! Anyway if i connect to DB via cmd (with --default-connection=latin1 for latin1 DB and --default-connection=utf-8 for utf-8 DB) i do not have charset problems, all umlauts and special characters are ok. As i mentioned earlier everything is ok expect 1-2 page visits per day .. Example: i visit the page at 08:00 --> everything ok i visit again at 12:00 --> umlauts broken --> charset problem i reload the page --> umlauts ok again everything ok till next 1-2 days
this is not a browser problem because i tested with different browser (lynx ecc.). And after writing explicitly to localconf.php: $TYPO3_CONF_VARS['SYS']['setDBinit'] = 'SET NAMES latin1'; the problem seems to be gone. So for me it looks like on Ubuntu the default connection character set (PHP -> MYSQL) changes from time to time. Could this be possible?! the problem isn't related to a certain typo3 version, the same happens for typo3 3.7, 4.2, 4.4 - Georg Am 27.05.2011 14:55, schrieb 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. > _______________________________________________ TYPO3-english mailing list TYPO3-english@lists.typo3.org http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english