XAMPP locally on Windows with UTF

[Jensensen]

when you install phpwcms locally for testing using XMAPP and UTF it could be a good idea to change/add:
setlocale(LC_CTYPE, 'C');

somewhere in your php script --> e.g. /root/index.php

Code: Select all

<?php
setlocale(LC_CTYPE, 'C');
....

don't know why [can't explain in short words] but leads to acceptable results:

and known umlaut probs... so
ü --> stays ü but without setlocale....
ü --> might become....strange....

Another issue: think about phpMyAdmin. When you open it you will see:
MySQL charset: UTF-8 Unicode (utf8)
MySQL connection collation: utf8_unicode_ci

and then two more crucial aspects follows:

A) Create new database --> select Collation
B) when installing phpwcms we must define
$phpwcms['db_charset'] = 'utf8'; or else
$phpwcms['db_collation'] = 'utf8_general_ci'; or else and this ONLY AFFECTS ONE TABLE (our phpwcms database) BUT NOT

MySQL charset: ...
MySQL connection collation: ...
and many web hoster, provider don't allow to change!
(phpMyAdmin running locally (XAMPP) grants much more rights than remote on a public web server!!!)

So, I guess, this might be one reason, because problems with character encodings after installation occurs...