How does the url autocompliter by plugin /rest/tinymce/1/wikixhtmlconverter work?

[Andrei Lomtev]

Atlassian Confluence  6.15.7 hosted

I try to insert two page urls from another space to the draft page. Both urls from the same space and same permissions and of course exist. But result of url autocomlite is different.

1) Success

curl 'https://wikibaseurl/rest/tinymce/1/wikixhtmlconverter' -H 'Connection: keep-alive' -H 'Pragma: no-cache' -H 'Cache-Control: no-cache' -H 'Accept: text/plain, */*; q=0.01' -H 'X-Requested-With: XMLHttpRequest' -H 'User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.79 Safari/537.36' -H 'Content-Type: application/json; charset=UTF-8' -H 'Origin: https://wikibaseurl' -H 'Sec-Fetch-Site: same-origin' -H 'Sec-Fetch-Mode: cors' -H 'Referer: https://wikibaseurl/pages/resumedraft.action?draftId=45220959&draftShareId=b507258d-6e61-43ca-bf47-a6e7688ddabe&' -H 'Accept-Encoding: gzip, deflate, br' -H 'Accept-Language: ru-RU,ru;q=0.9,en-US;q=0.8,en;q=0.7' -H 'Cookie: _ga=GA1.2.1301953585.1579498112; seraph.confluence=42139704%3A7479c10a0d86baeee2014d97b75336aae83595bd; _gid=GA1.2.1925663952.1580101446; JSESSIONID=5945B1AA233899B939B44EE990110804; mywork.tab.tasks=false' --data-binary '{"wiki":"[$7284600]","entityId":"45220958","spaceKey":"DEVOPS"}' --compressed

Response body

<p><a class="confluence-link" href="/pages/viewpage.action?pageId=7284600" data-linked-resource-id="7284600" data-linked-resource-version="297" data-linked-resource-type="page" data-linked-resource-default-alias="PageTitleText1" data-base-url="https://wikibaseurl">PageTitleText1</a></p>

2) Unsuccess
curl 'https://wikibaseurl/rest/tinymce/1/wikixhtmlconverter' -H 'Connection: keep-alive' -H 'Pragma: no-cache' -H 'Cache-Control: no-cache' -H 'Accept: text/plain, */*; q=0.01' -H 'X-Requested-With: XMLHttpRequest' -H 'User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.79 Safari/537.36' -H 'Content-Type: application/json; charset=UTF-8' -H 'Origin: https://wikibaseurl' -H 'Sec-Fetch-Site: same-origin' -H 'Sec-Fetch-Mode: cors' -H 'Referer: https://wikibaseurl/pages/resumedraft.action?draftId=45220959&draftShareId=b507258d-6e61-43ca-bf47-a6e7688ddabe&' -H 'Accept-Encoding: gzip, deflate, br' -H 'Accept-Language: ru-RU,ru;q=0.9,en-US;q=0.8,en;q=0.7' -H 'Cookie: _ga=GA1.2.1301953585.1579498112; seraph.confluence=42139704%3A7479c10a0d86baeee2014d97b75336aae83595bd; _gid=GA1.2.1925663952.1580101446; JSESSIONID=5945B1AA233899B939B44EE990110804; mywork.tab.tasks=false' --data-binary '{"wiki":"[$7282186]","entityId":"45220958","spaceKey":"DEVOPS"}' --compressed

Response body

<p><a class="confluence-link createlink" href="/pages/createpage.action?spaceKey=IT&amp;title=PageTitleText2" data-content-title="PageTitleText2" data-space-key="IT">PageTitleText2</a></p>

[Andrei Lomtev · Accepted solution]

selfresolved. The problem was with db collation