Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Re: MySQL importing error
Sencer, I realise its not TXD’s fault, I just want to solve the problem :0
TXD support suggested “converting the data to utf-8. There are a lot tools which can do that (iconv), but the most simple is probably to load the database dump in SubEthaEdit and convert it to UTF-8 via the menu”.
I tried converting with Text Wrangler but that produces SQL errors. I could try iconv, but I would still have problems with problems with punBB and PhotoPost, since they are iso-8859-1.
Someone suggested I could change the collation of the database via phpMyAdmin, but I don’t see how that would help, since 4.1 is already iso-8859-1 I believe.
I am not going to be able to change the code of punBB and PP to specify the charset of the db connection, so I feel really stumped.
Offline