Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Re: Odd Characters, Blank Templates
can you change it to latin1 and see what happens?
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
Re: Odd Characters, Blank Templates
colak wrote #313241:
can you change it to
latin1and see what happens?
I did change it to latin1 and it now reports:
Charset (default/config): latin1/latin1
character_set_client: latin1
character_set_connection: latin1
character_set_database: latin1
character_set_filesystem: binary
character_set_results: latin1
character_set_server: latin1
character_set_system: utf8
character_sets_dir: /usr/share/mysql/charsets/
So it works just the same. Right now the only trouble we seem to be having is that the language pages are still screwed up and, more importantly, a paragraph that begins and ends with single or double quotes typed from the keyboard doesn’t display.
Offline
Re: Odd Characters, Blank Templates
i know i had a devil of a time in getting my old EEcms site updated from Latin-1 to UTF-8.
i ended up having manually change the odd characters one-by-one.
Odd that MySQL itself can’t repair its character sets via some script.
…. texted postive
Offline
Re: Odd Characters, Blank Templates
Yeah, the characters are all fixed and the site seems to be working well. It’s the problem with the typed quotes that’s driving me crazy. My big site Wandering Italy has the same database coding and has worked fine for years and years. Strange.
Offline
Re: Odd Characters, Blank Templates
The characters look like they are fixed because the database tables are now called correctly from textpattern because of your change to the config file.
I would still try to convert the database to utf8.
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
Re: Odd Characters, Blank Templates
jakob wrote #313108:
I read you did a database upgrade on this thread but saw no difference in the files. You can check if that is really the case by exporting your updated database and then comparing the old and new using a diff tool.
One further idea – do you have the line:
$txpcfg['dbcharset'] = 'utf8';...as shown here in your
config.phpfile?If you want some off-forum assistance, send me an email…
Thanks Jakob. I used the database you provided me and I had the same problems. Same database diagnostics, same dropping of paragraphs with quotes.
BUT, then I looked at the languages page again and it said I was using US English. So I downloaded EN-GB and switched to British English and…everything is displaying fine again, even the languages page. I can also use special characters. Diagnostics on the database haven’t changed, but I’m happy it’s fixed.
Thanks again.
Offline
Re: Odd Characters, Blank Templates
Glad you got it working. That’s a very strange error. Would be good to find out why that’s happening. I wasn’t aware there was a difference regarding the encoding of quotes in US- and UK- English. They should both work equally well, also with Latin1 and UTF-8.
Perhaps there was an error with your US-English language files. Maybe you can re-download and re-import the corresponding US-English language files (or delete US-English, then re-add) for your version and see if that works. Maybe it was somehow incomplete. I tried your db with a fresh-installation downloaded directly from textpattern.com and didn’t observe that phenomenon.
TXP Builders – finely-crafted code, design and txp
Offline