phpMyAdmin / Patches / #506 (ok 3.3.2) XML export wrongly encoded

#506 (ok 3.3.2) XML export wrongly encoded

Status: closed-fixed

Owner: Marc Delisle

Labels: Data Export (42)

Priority: 1

Updated: 2010-04-14

Created: 2010-03-27

Creator: Victor Volkov

Private: No

Trying to export to XML we have a porblem with function utf8_encode() that exist in file /libraries/export/xml.php on line 340. All data in russian (utf8 or cp1251, no matter) looks like ÐÐ»Ð°Ð²Ð½Ð°Ñ.

If we will change this line:
$buffer .= ' <column name="' . $columns[$i] . '">' . htmlspecialchars(utf8_encode((string)$record[$i]))

To this one:
$buffer .= ' <column name="' . $columns[$i] . '">' . htmlspecialchars((string)$record[$i])

The problem is gone.

Discussion

Marc Delisle - 2010-03-27

Hi Victor,
Please attach here a small SQL export of your table, I want to be sure that your data is correctly stored in the original table.

See also http://wiki.phpmyadmin.net/pma/Garbled_data

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Victor Volkov - 2010-03-27

2 rows with Russian text in it (utf8)

vb_forum_test.sql.gz

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Victor Volkov - 2010-03-27

Yes, sure. Did upload the file with 2 rows and Russian text in it in utf8.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Victor Volkov - 2010-03-27

Sorry, forgot to tell you, it's phpMyAdmin 3.3.1.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2010-03-30

assigned_to: nobody --> lem9
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2010-03-30

labels: 546627 --> Data Export
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2010-03-30

Moved to patches

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2010-03-30

priority: 5 --> 1

summary: XML export problem --> (ok 3.3.2) XML export wrongly encoded

status: open --> open-fixed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2010-03-30

Your patch was merged in the repository, thanks.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2010-04-14

status: open-fixed --> closed-fixed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

(ok 3.3.2) XML export wrongly encoded

A software tool to bring MySQL to the Web

Group

Searches

Help

#506 (ok 3.3.2) XML export wrongly encoded

Discussion