`occ fulltextsearch:index` gets stuck on file names that contain emoji

How to use GitHub

• Please use the 👍 reaction to show that you are affected by the same issue.
• Please don't comment if you have no relevant information to add. It's just extra noise for everyone subscribed to this issue.
• Subscribe to receive notifications on status change and new comments.

Steps to reproduce

1. Run occ fulltextsearch:index
2. Wait for it to hit a filename containing emoji.

Expected behaviour

That it wouldn't get stuck on file names that contain emoji.

Actual behaviour

Gets stuck on file names containing emoji. This is a problem when a lot of Markdown editors for keeping notes tend to involve emojis in the file names so that navigating notes is more efficient to parse by symbol instead of a big list of words.

Server configuration

Web server: Nginx

Database: PostgreSQL

PHP version: 8.3

Nextcloud version: 31.0.9

Browser

Browser name: Firefox/Chrome/Safari/…

Browser version: 124/125/…

Operating system: Windows/Ubuntu/Mac/…

Insert your browser log here, this could for example include:
a) The javascript console log
b) The network log
c) ...

Start by running occ fulltextsearch:index against a file whose name contains emoji and inspect where indexing stops. Trace the full-text search indexing path from that command; done means the index completes without getting stuck on emoji-containing filenames.