Hope, someone can help me, because I'm going to get mad!
Either there is something wrong with phpMyAdmin configuration under XAMPP Lite for Windows (because I can't reproduce this problem in any on-line pma, I use, only in this one) or I don't understand something.
I have a HORRIBLE problems with configuring pma (and MySQL) charsets to other than default, that comes with XAMPP Lite installation.
I've opened config.inc.php in phpMyAdmin dir and added these two:
- Code: Select all
$cfg['DefaultConnectionCollation'] = 'latin2_general_ci';
$cfg['DefaultCharset'] = 'iso-8859-2';
I've opened my.cnf i mysql/bin dir and added these two:
- Code: Select all
character-set-server = latin2
collation-server = latin2_general_ci
And even so, after loggin into pma I STILL see this anying (for me) text: "MySQL charset: UTF-8 Unicode (utf8)".
I have no idea how to change it into ISO-Latin-2 (ISO 8859-2), which I use and how to grant that all my mysql transactions will be performed with correct (for me) character coding.
I have NO server- or user-specific configuration neither for mysql nor for pmy. Everywhere I use global settings but either I don't understand them or something is wrong. I really would like to get rid of that utf-8 encoding because all my on-line server uses iso-latin-2 encoding and each time I migrate from local to on-line version of my pages I have to update my databases - i.e re-encode their characters.
And speaking about languages and charsets. Can someone tell me what is wrong with this line of pma configuration:
- Code: Select all
$cfg['Lang'] = 'polish-iso-8859-1';
or even
- Code: Select all
$cfg['Lang'] = 'polish-utf-8';
Because if I include it in my pma config I always get "Language not found" error message when logging into pma. This is another xampp-lite-pma related problem for me because I have no such a problems when using pma on Apache server configured by my on-line server administrator. OF course all files that I try to point to (i.e. polish-iso-8859-1 and polish-utf-8) are EXISTING in my lang folder. It is only that I can't change language (by configuration! - because through combo box in pma works well) to any other than default one.
Best regards and thanks for all help!
Tom