Thread: [adminer-tracker] [ adminer-Bugs and Features-3418275 ] Problem displaying correct encoding
Database management in a single PHP file
Brought to you by:
jakubvrana
From: SourceForge.net <no...@so...> - 2011-10-04 08:35:00
|
Bugs and Features item #3418275, was opened at 2011-10-04 10:34 Message generated for change (Tracker Item Submitted) made by h4ever You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3418275&group_id=264133 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: MySQL Group: 3.3.3 Status: Open Resolution: None Priority: 5 Private: No Submitted By: H4ever (h4ever) Assigned to: Jakub Vrána (jakubvrana) Summary: Problem displaying correct encoding Initial Comment: I have found common problem for both phpmyadmin and adminer, both show incorrectly encoding of data that I have in my mysql database. I already have solved the problem. So I have utf8 encoding and database and tables set to utf8_czech_ci . My application works fine, but adminer does not show correct encoding. I found that mysql command SET NAMES and/or php command $this->set_charset("utf8"); overwrites collation by default values, which is Swedish. (I did not set Swedish, but Swedish is set as default language in mysql). So even I need to get Czech collation I got the Swedish one. The solution for me was to escape line with $this->set_charset("utf8"); and SET NAMES and to insert there these lines: $this->query("SET character_set_connection='utf8_czech_ci'"); $this->query("SET COLLATION_CONNECTION= 'utf8_czech_ci'"); $this->query("SET character_set_results='utf8_czech_ci'"); I think that using SET NAMES and/or set_charset("utf8"); is unlucky! ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3418275&group_id=264133 |
From: SourceForge.net <no...@so...> - 2011-10-04 17:07:50
|
Bugs and Features item #3418275, was opened at 2011-10-04 10:34 Message generated for change (Comment added) made by jakubvrana You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3418275&group_id=264133 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: MySQL Group: 3.3.3 >Status: Closed >Resolution: Invalid Priority: 5 Private: No Submitted By: H4ever (h4ever) Assigned to: Jakub Vrána (jakubvrana) Summary: Problem displaying correct encoding Initial Comment: I have found common problem for both phpmyadmin and adminer, both show incorrectly encoding of data that I have in my mysql database. I already have solved the problem. So I have utf8 encoding and database and tables set to utf8_czech_ci . My application works fine, but adminer does not show correct encoding. I found that mysql command SET NAMES and/or php command $this->set_charset("utf8"); overwrites collation by default values, which is Swedish. (I did not set Swedish, but Swedish is set as default language in mysql). So even I need to get Czech collation I got the Swedish one. The solution for me was to escape line with $this->set_charset("utf8"); and SET NAMES and to insert there these lines: $this->query("SET character_set_connection='utf8_czech_ci'"); $this->query("SET COLLATION_CONNECTION= 'utf8_czech_ci'"); $this->query("SET character_set_results='utf8_czech_ci'"); I think that using SET NAMES and/or set_charset("utf8"); is unlucky! ---------------------------------------------------------------------- >Comment By: Jakub Vrána (jakubvrana) Date: 2011-10-04 19:07 Message: If Adminer shows wrong characters then it means that you have stored wrong characters in the database. Fix your application to call set_charset and convert your data. Maybe http://php.vrana.cz/prevod-kodovani-mysql.php can help you. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3418275&group_id=264133 |