Textpattern CMS

#13 2006-12-09 03:33:17

backspaces

Member

From: Santa Fe, NM

Registered: 2004-09-10

Posts: 15

Website

Re: Character Code Problems

Mary wrote:

Your local Textpattern’s config.php will need to be latin1 too.

Converting from latin1 to utf-8 can be tricky, it’s not really something for beginners. But, you can try if you want to, just make sure you don’t modify the original database or the backup for it (always work on a copy of the db dump). Some relevant links:

• Convert latin1 to UTF-8 in MySQ
• Converting MySQL Database Contents to UTF-8

Thanks! I’ll let folks know how it works, although possibly after Christmas, it’s crazy at our house now!

I had thought of iconv of my dumps, but I was concerned that MySql might want ASCII or some such for the MySql parts, requiring a fairly sophisticated script to apply iconv only to the content of the dump.

Thanks so much for the help, by the way.

Owen