[Bug]: Can't create tag with some Thai characters from Files and Recognize

⚠️ This issue respects the following points: ⚠️

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

Bug description

Because problem persists across two (or more apps) and same entry can be created directly using psql, belief is it is at Server/core level.
Problem is of nature that can't create tag with some Thai characters from Files and Recognize .

"Classifier process output: [\n  {\n    className: '\u0e1e\u0e23\u0e30\u0e17\u0e35\u0e48\u0e19\u0e31\u0e48\u0e07\u0e2d\u0e32\u0e20\u0e23\u0e13\u0e4c\u0e20\u0e34\u0e42\u0e21\u0e01\u0e02\u0e4c\u0e1b\u0e23\u0e32\u0e2a\u0e32\u0e17',\n    probability: 0.9035003781318665\n  }\n]\n","userAgent":"--","version":"27.1.2.1","data":{"app":"recognize"}}

Worth mentioning that other tag with Thai letters could be created from Files: อินพุต-NC-level-tagged

version: 27.1.2.1

Steps to reproduce

1. Create file or folder.
2. Try to create tag from Files: พระที่นั่งอาภรณ์ภิโมกข์ปราสาท

Expected behavior

Create tag without an error.

Installation method

Docker (Debian)

Nextcloud Server version

27

Operating system

None

PHP engine version

8.2

Web server

Nginx

Database engine version

Postgres

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

None

Are you using the Nextcloud Server Encryption module?

None

What user-backends are you using?

• Default user-backend (database)
• LDAP/ Active Directory
• SSO - SAML
• Other

Configuration report

No response

List of activated Apps

No response

Nextcloud Signing status

No response

Nextcloud Logs

"app":"core","method":"","url":"/cron.php","message":"Error while running background job (class: OCA\\Recognize\\BackgroundJobs\\ClassifyLandmarksJob, arguments: Array\n(\n    [storageId] => 10\n    [rootId] => 31946\n)\n)","userAgent":"--","version":"27.1.2.1","exception":{"Exception":"Doctrine\\DBAL\\Exception\\DriverException","Message":"An exception occurred while executing a query: SQLSTATE[22021]: Character not in repertoire: 7 ERROR:  invalid byte sequence for encoding \"UTF8\": 0xe0\nCONTEXT:  unnamed portal parameter $1","Code":7,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1814,"function":"convert","class":"Doctrine\\DBAL\\Driver\\API\\PostgreSQL\\ExceptionConverter","type":"->","args":[["Doctrine\\DBAL\\Driver\\PDO\\Exception"],["Doctrine\\DBAL\\Query"]]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1749,"function":"handleDriverException","class":"Doctrine\\DBAL\\Connection","type":"->","args":[["Doctrine\\DBAL\\Driver\\PDO\\Exception"],["Doctrine\\DBAL\\Query"]]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1055,"function":"convertExceptionDuringQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":[["Doctrine\\DBAL\\Driver\\PDO\\Exception"],"SELECT * FROM \"oc_systemtag\" WHERE (\"name\" = ?) AND (\"visibility\" = ?) AND (\"editable\" = ?)",[null,1,1],[]]},{"file":"/var/www/html/lib/private/DB/Connection.php","line":262,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":["SELECT * FROM \"oc_systemtag\" WHERE (\"name\" = ?) AND (\"visibility\" = ?) AND (\"editable\" = ?)",[null,1,1],[],null]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":345,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT * FROM \"oc_systemtag\" WHERE (\"name\" = :name) AND (\"visibility\" = :visibility) AND (\"editable\" = :editable)",[null,1,1],[]]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/SystemTag/SystemTagManager.php","line":186,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/custom_apps/recognize/lib/Service/TagManager.php","line":31,"function":"getTag","class":"OC\\SystemTag\\SystemTagManager","type":"->","args":["*** sensitive parameters replaced ***",true,true]},{"file":"/var/www/html/custom_apps/recognize/lib/Service/TagManager.php","line":71,"function":"getTag","class":"OCA\\Recognize\\Service\\TagManager","type":"->","args":["*** sensitive parameters replaced ***"]},{"function":"OCA\\Recognize\\Service\\{closure}","class":"OCA\\Recognize\\Service\\TagManager","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/custom_apps/recognize/lib/Service/TagManager.php","line":70,"function":"array_map","args":[["Closure"],["landmark","*** sensitive parameters replaced ***"]]},{"file":"/var/www/html/custom_apps/recognize/lib/Classifiers/Images/LandmarksClassifier.php","line":47,"function":"assignTags","class":"OCA\\Recognize\\Service\\TagManager","type":"->","args":[531275,["landmark","*** sensitive parameters replaced ***"]]},{"file":"/var/www/html/custom_apps/recognize/lib/BackgroundJobs/ClassifyLandmarksJob.php","line":41,"function":"classify","class":"OCA\\Recognize\\Classifiers\\Images\\LandmarksClassifier","type":"->","args":[[["OCA\\Recognize\\Db\\QueueFile",343962],["OCA\\Recognize\\Db\\QueueFile",343963],["OCA\\Recognize\\Db\\QueueFile",343964],
[...CUT...]
["OCA\\Recognize\\Db\\QueueFile",346040],["OCA\\Recognize\\Db\\QueueFile",346041],["OCA\\Recognize\\Db\\QueueFile",346042],["OCA\\Recognize\\Db\\QueueFile",346043],["OCA\\Recognize\\Db\\QueueFile",346044]]]},{"file":"/var/www/html/custom_apps/recognize/lib/BackgroundJobs/ClassifierJob.php","line":73,"function":"classify","class":"OCA\\Recognize\\BackgroundJobs\\ClassifyLandmarksJob","type":"->","args":[[["OCA\\Recognize\\Db\\QueueFile",343962],["OCA\\Recognize\\Db\\QueueFile",343963],["OCA\\Recognize

[...cut...]

\\QueueFile",346041],["OCA\\Recognize\\Db\\QueueFile",346042],["OCA\\Recognize\\Db\\QueueFile",346043],["OCA\\Recognize\\Db\\QueueFile",346044]]]},{"file":"/var/www/html/custom_apps/recognize/lib/BackgroundJobs/ClassifyLandmarksJob.php","line":33,"function":"runClassifier","class":"OCA\\Recognize\\BackgroundJobs\\ClassifierJob","type":"->","args":["landmarks",[10,31946]]},{"file":"/var/www/html/lib/public/BackgroundJob/Job.php","line":81,"function":"run","class":"OCA\\Recognize\\BackgroundJobs\\ClassifyLandmarksJob","type":"->","args":[[10,31946]]},{"file":"/var/www/html/lib/public/BackgroundJob/TimedJob.php","line":103,"function":"start","class":"OCP\\BackgroundJob\\Job","type":"->","args":[["OC\\BackgroundJob\\JobList"]]},{"file":"/var/www/html/lib/public/BackgroundJob/TimedJob.php","line":93,"function":"start","class":"OCP\\BackgroundJob\\TimedJob","type":"->","args":[["OC\\BackgroundJob\\JobList"]]},{"file":"/var/www/html/cron.php","line":152,"function":"execute","class":"OCP\\BackgroundJob\\TimedJob","type":"->","args":[["OC\\BackgroundJob\\JobList"],["OC\\Log"]]}],"File":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","Line":101}},"message":"Error while running background job (class: OCA\\Recognize\\BackgroundJobs\\ClassifyLandmarksJob, arguments: Array\n(\n    [storageId] => 10\n    [rootId] => 31946\n)\n)","exception":{},"CustomMessage":"Error while running background job (class: OCA\\Recognize\\BackgroundJobs\\ClassifyLandmarksJob, arguments: Array\n(\n    [storageId] => 10\n    [rootId] => 31946\n)\n)"}}

### Additional info

_No response_

Reproduce the issue by creating the Thai tag from Files, then inspect custom_apps/recognize/lib/Service/TagManager.php and lib/private/SystemTag/SystemTagManager.php around the PostgreSQL query shown in the log. Trace the call from LandmarksClassifier.php and ClassifyLandmarksJob.php; done means the tag can be created and the recognition background job completes without the encoding error.