Summary

When exporting a page that has an apostrophe ’ in its title, the XML result will change it to a single quote ' instead.
If you have a another page PageA linked to the page with apostrophe title for example Test ABC’s, the internal link escapes the apostrophe properly in the URL but the page name has already changed to Test ABC's after the import. So the link will fail.

Environment

Reproduced on 5.6.3, 5.9.6, 5.9.7

Steps to Reproduce

1. Create a new page with this name Test ABC’s
2. Create another page PageA and insert a link to the page Test ABC’s
3. Save and export those pages by XML backup
4. Import the XML

Expected Results

Both pages should be imported successfully with the proper names and the internal link should be working.

Actual Results

PageA is imported properly, but the other page title becomes Test ABC's instead of Test ABC’s. Internal link is broken as well because the page name has changed.

Workaround

The workaround is to update the page title from the database manually

UPDATE CONTENT
SET TITLE = REPLACE(TITLE, 'ABC''s', 'ABC’s')
WHERE SPACEID = <space_id> AND TITLE = 'Test ABC''s'