Problem with pma charset configuration
Posted: 13. April 2008 07:02
Hello there,
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:
I've opened my.cnf i mysql/bin dir and added these two:
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:
or even
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
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