[Bug]: MacOS Virtual File with french character issue

[xavi-b]

⚠️ Before submitting, please verify the following: ⚠️

• This is a bug, not a question or a configuration issue.
• This issue is not already reported on Github (I've searched it).
• Nextcloud Server and Desktop Client are up to date. See Server Maintenance and Release Schedule and Desktop Releases for supported versions.
• I agree to follow Nextcloud's Code of Conduct

Bug description

When you try to open a file called vidéo.txt.nextcloud (since it is not in local) in a Nextcloud sync folder, it does nothing and the logs say : "Did not find file in db"

Steps to reproduce

1. Double click on the file
2. It does not download locally and does not open

Expected behavior

When double-clicking on the file it should download and open

Which files are affected by this bug

folder.cpp syncjournaldb.cpp

Operating system

Mac OS

Which version of the operating system you are running.

12.6

Package

Compiled it myself

Nextcloud Server version

24.0.3

Nextcloud Desktop Client version

3.6.0

Is this bug present after an update or on a fresh install?

Fresh desktop client install

Are you using the Nextcloud Server Encryption module?

Encryption is Disabled

Are you using an external user-backend?

• Default internal user-backend
• LDAP/ Active Directory
• SSO - SAML
• Other

Nextcloud Server logs

No response

Additional info

No response

[JackGlobetrotter]

Hello,
i am having the same issu, i think i have traced it down a little more.

Whenever i try to open a file with some special character (like è), the log show the folowing error

 info nextcloud.gui.folder /var/folders/yr/***/T/macos-11939/src/gui/folder.cpp:612 ]:	Implicitly hydrate virtual file: "***thèse.pdf.nextcloud"
***
[ info nextcloud.gui.folder /var/folders/yr/***/T/macos-11939/src/gui/folder.cpp:618 ]:	Did not find file in db

I tried searching the file myself in the db (OC_FILECACHE) while copy-pasting the name -> it did not yield any result
I tried searching for the file name writing it myself -> found it

So i looked at the character encoding for the searched file by the macos client, turns out è is encoded as "65 cc 80", whereas the default as typed with the keyboard "è" character (typed with the keyboard) is encoded as "c3 a8".

In conclusion i believe the file is not found because the macos client sends the wrong character (or maybe the file name is encoded with the wrong character from the beginning? ).