[TYPO3-english] Problems with high-ASCII in front end only...

[Bob]

Thanks Michael. I found a few online solutions, including a script that 
was supposed to fix a TYPO3 DB, but didn't seem to do so.

In the end, I set up a new installation of TYP03 (with a fresh UTF-8 
database and [BE][forceCharset] set to "utf-8"), imported a T3D of the 
previous version, then manually fixed all the scrambled characters by 
copying and pasting from the back-end of the old site to the back-end of 
the new site.

Fortunately, the site wasn't *too* big...


On 10/10/2011 08:53, Michael Cannon wrote:
> Bob,
>
> You could go for a mysqldump, convert the characters and reimport.
>
> One way is at
> http://en.gentoo-wiki.com/wiki/Convert_latin1_to_UTF-8_in_MySQL.
>
> Michael
> --
> Michael Cannon
> The TYPO3 Vagabond<http://typo3vagabond.com/>
> Been there, done that, 25 years of coding
> Germany +49 8031 220 95 53
> US +1 617 539 6072