Menu

#1282 Save then Load from database (PostgreSQL) adds extra "\" to existing text.

next release
open
nobody
None
5
2015-09-16
2015-06-15
Fred
No

Hi,

Just tried out 2.11b2. While everything else seems to be working quite well, I did notice that when I export to an external database (PostgreSQL) and then import it, any escaped characters have an added escape each time the database is exported to the RDBMS and then re imported.

For example:

load from external database. Author column of this entry contains the following:
K{\\\\"{o}}hrle, Josef

Save and then reload from PostgreSQL database:
K{\\\\\\\\"{o}}hrle, Josef

The original text was:
K{\"{o}}hrle, Josef

Exporting to an external database and then importing it causes the difficulty.

My suspicion is that some PostgreSQL function is adding extra escape characters before storing in the database.

Thank you,

Fred

Discussion

  • Stefan Kolb

    Stefan Kolb - 2015-08-07
     
  • Fred

    Fred - 2015-08-07

    Hi,

    Tried the patch to DBExporter.java on the dev_2.11 branch. The same behavior still exists. I haven't tried on master yet. If I have time this weekend, I will try there.

    Cheers,

    Fred

     
  • Stefan Kolb

    Stefan Kolb - 2015-08-07

    This PR is not merged yet, so I don't expect any changes in either of the branches.

     
  • Fred

    Fred - 2015-09-16

    This is still present in 2.11b4. I tried it just now with same results as initially.

     

Log in to post a comment.