Export MySQL-->.siard: Change of metadata.xml content in case of Quotation-Marks and Empty Spaces

[ibbenz]

Description:

1. Uploading the attached Inputfile via dbptk, additional empty spaces are added to column descriptions (see attached images

2. Downloading Data from MySQL, single quotation marks and Empty spaces in the metadata are transformed in unicode. Single Quotation Mark ' --> 's Empty Space --> \u0020

Steps required to reproduce the bug:

1. Upload the Input file in a MySQL-DB using dbptk (see attached files)
2. Download Data from MySQL into .siard File. The file should correspond to the attached output-file.
3. Compare the metadata "Column description" of the colums (e.g. in table "employees" the column "Title") of Input and Outputfile.

Attach the dbptk-app.log.txt file below. dbvtk.log

Images, which illustrate the change: 2022_07_10_dbptk_V06.siard, uploaded in MySQL by dbptk:

Depiction of original 2022_07_10_dbptk_V06.siard and resulting 2022_07_10_dbptk_V06_MySQL2SIARD_dbptk.siard in SiardSuite. Depiction of metadata.xml of 2022_07_10_dbptk_V06_MySQL2SIARD_dbptk.siard

Input File: Uploaded .siard File to MySQL using dbptk: 0_1-3_Northwind_simple_2022_07_10_dbptk_V06.zip

Output File: Downloaded File from MySQL using dbptk: 2022_07_10_dbptk_V06_MySQL2SIARD_dbptk.zip