Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
How to fix character misfits ... !?
Transfering database tables from local (MAMP PRO, Transmit) to server gives some character inequalities. As in articles and so on the site (screenshots) >
Where do I start to tackle this? It’s most probably a character set disfunction, but all is set to utf-8 or utf8-general-ci … as far I can see.
Textpattern versie: 4.5.7 (r5900)
Laatste update: 2015-11-11 11:22:00/2015-11-11 11:21:11
Document root: /domains/joopvos.nl/DEFAULT
$path_to_site: /domains/joopvos.nl/DEFAULT
Pad naar textpattern: /domains/joopvos.nl/DEFAULT/textpattern
Permanente link modus: section_title
Tijdelijke bestanden map: /domains/joopvos.nl/DEFAULT/textpattern/tmp
URL van de site: joopvos.nl
PHP versie: 5.6.27-1~dotdeb+7.1
GD Graphics Library: bundled (2.1.0 compatible); ondersteunde bestandssoorten: GIF, JPG, PNG.
Server TZ: Europe/Amsterdam
Lokale servertijd: 2016-11-28 19:59:44
Zomertijd: 0
Zomer- en wintertijd automatisch bijstellen?: 1
Tijdzone: Europe/Amsterdam (3600)
MySQL: 5.5.48-MariaDB-1~wheezy
Localisatie: nl_NL.UTF-8
Server: Apache
Apache versie: Apache
PHP server API: apache2handler
RFC 2616 headers:
Besturingssysteem van de server: Linux 3.18.44
Actieve plugins: jra_ext_link-0.2a, adi_mobile-0.2, zem_contact_reborn-4.0.3.21, zem_contact_lang-4.0.3.6m, rah_replace-0.4.2, smd_macro-0.30m, stm_article_order-0.3m, upm_textile-0.3, tom_image_grid-0.3, wet_peex-1.0, wet_quicklink-0.8.2, adi_notes-1.3.1, smd_thumbnail-0.31
Vormgeving sitebeheer: classic 4.5.7Pre-flight controle:
————————————
Nieuwe textpattern versie 4.6.2 beschikbaar voor download.
————————————Inhoud .htaccess bestand:
————————————
#DirectoryIndex index.php index.html#Options +FollowSymLinks
#Options -Indexes
#ErrorDocument 403 default<IfModule mod_rewrite.c> RewriteEngine On #RewriteBase /relative/web/path/
RewriteCond %{REQUEST_FILENAME} -f [OR] RewriteCond %{REQUEST_FILENAME} -d RewriteRule ^(.+) – [PT,L]
RewriteCond %{REQUEST_URI} !=/favicon.ico RewriteRule ^(.*) index.php
RewriteCond %{HTTP:Authorization} !^$ RewriteRule .* – [E=REMOTE_USER:%{HTTP:Authorization}]
</IfModule>#php_value register_globals 0
- SVG
AddType image/svg+xml svg svgz
AddEncoding gzip svgz
————————————
Last edited by RedFox (2016-11-28 19:02:43)
Offline
Re: How to fix character misfits ... !?
Oh oh oh. I am dealing with the same problem right now, here (no solution yet)
Wisdom until now after two days of misfits shows at least, that if you go UTF8, then go it all the way, Don’t try to mix Latin1 with UTF8, if you don’t need to.
A hole turned upside down is a dome, when there’s also gravity.
Offline
Re: How to fix character misfits ... !?
Do you have $txpcfg['dbcharset'] = 'utf8mb4';
in the config file?
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: How to fix character misfits ... !?
Colak, what difference to plain utf8 would that make?
A hole turned upside down is a dome, when there’s also gravity.
Offline
Re: How to fix character misfits ... !?
Colak, thank you for pointing me to the config file. Locally it says $txpcfg['dbcharset'] = 'latin1';
… on the server: $txpcfg['dbcharset'] = 'utf8';
. Changing the last one into latin1
… no garbled data anymore … :)
Last edited by RedFox (2016-11-29 05:22:11)
Offline
Re: How to fix character misfits ... !?
RedFox, may i ask, what kind of collation you use in your server database tables?
A hole turned upside down is a dome, when there’s also gravity.
Offline
Offline
Re: How to fix character misfits ... !?
Thanx for posting, now that’s interesting. How comes you want to mix utf8 and latin1 collated tables in one database? I was under the impression, that this is a risky thing to do, but have no knowledge of this otehrwise…
A hole turned upside down is a dome, when there’s also gravity.
Offline
Re: How to fix character misfits ... !?
jayrope wrote #303072:
… but have no knowledge of this …
Me neither … :|
Maybe this post can help > garbled data
Last edited by RedFox (2016-11-28 22:34:40)
Offline
Re: How to fix character misfits ... !?
Thank you, very good hints in there!
A hole turned upside down is a dome, when there’s also gravity.
Offline