Platon Technologies
not logged in Login Registration
EnglishSlovak
open source software development celebrating 10 years of open source development! Wednesday, November 11, 2026
About Us
Magazine
Open Source
CVS
Services
Index  »  Projects  »  phpMyEdit  »  Forum  »  Does not display data with accents
Main | View Bugs | Report Bug | Summary | Forum | Documentation | Download

phpMyEdit General     Does not display data with accents
Post new topic   Reply to topic    
 
raffaelssp     Joined: 31 Dec 2014   Posts: 2  
Post Posted: 2014-12-31 19:29
Back to top  Reply with quote     

I'm in trouble, for every field that has accents does not display returns empty


How to fix this error

 
doug     Joined: 10 Feb 2003   Posts: 1013   Location: Denver, Colorado (USA)
Post Posted: 2014-12-31 21:03
Back to top  Reply with quote     

Empty? Or with strange characters?

Maybe an issue with encoding if strange characters:
http://archive.oreilly.com/pub/post/turning_mysql_data_in_latin1_t.html

Post a link to an example, or a link to screen shot image.

 
raffaelssp     Joined: 31 Dec 2014   Posts: 2  
Post Posted: 2015-01-01 13:48
Back to top  Reply with quote     

Example:

https://drive.google.com/file/d/0B7-V-Arm2QrOTmJoNENCbWtURXM/view?usp=sharing

 
doug     Joined: 10 Feb 2003   Posts: 1013   Location: Denver, Colorado (USA)
Post Posted: 2015-01-01 20:13
Back to top  Reply with quote     

Post some code, like the field definitions.
http://opensource.platon.org/projects/doc.php/phpMyEdit/html/configuration.fields.html

 
scameron@siu.edu     Joined: 18 Mar 2013   Posts: 1  
Post Posted: 2015-01-10 23:21
Back to top  Reply with quote     

I believe I am having the same problem. For example a column that contains a degree symbol shows empty in phpmyedit.

U+00B0 ° c2 b0 DEGREE SIGN

 
doug     Joined: 10 Feb 2003   Posts: 1013   Location: Denver, Colorado (USA)
Post Posted: 2015-01-10 23:38
Back to top  Reply with quote     

These issues are almost always related to encoding errors (and NOT to phpMyEdit).

http://www.toptal.com/php/a-utf-8-primer-for-php-and-mysql

http://archive.oreilly.com/pub/post/turning_mysql_data_in_latin1_t.html

 
dogsbreath1     Joined: 04 Mar 2015   Posts: 2  
Post Posted: 2015-03-04 17:51
Back to top  Reply with quote     

I had this problem today and the solution is:

1. Replace each 'htmlspecialchars(...)' with 'fhtmlspecialchars(...)'

2. Add the function 'fhtmlspecialchars':
function fhtmlspecialchars($myString) {
// in PHP 5.4 the default encoding used by htmlspecialchars() was changed.
return htmlspecialchars($myString, ENT_COMPAT, 'ISO-8859-1', true);
}

Thank you Atara.H.

 
Post new topic   Reply to topic    

Main | View Bugs | Report Bug | Summary | Forum | Documentation | Download
Copyright © 2002-2006 Platon Group
Site powered by Metafox CMS 		Go to Top · Feedback form · Application form
Report bug on PLATON.SK website · Terms of use · Privacy policy