[Bug]: SQL errors when inserting data (Data too long for column 'name')

[nc-fkl]

⚠️ 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

An user try to upload file with a big file name, but the SQL column size is too small.
The frontend should already decline the upload of that file.

Steps to reproduce

1. Select a file with a real long filename ( for example: remote.php/webdav/123/abc-defg-hijklmn/img/qr/SnhJUDAwdDU0WHNEWEloYlZNV2RLTnJEdk9xQUt3Z3NEcEZNUk9SL0V2NVFLamJ1TzdJT2dNMzVrSm5IcGVGWFdXUzI3aDZ1QU84S0NVZno5UTZheUdXZExqenkzMTYrd2xYZWJTczlnSEpqdENXL0hqcGFMVTZNOW5NR3ZlM1poK3ZJQUczYwdesgrdhfghnvcbcxfsefsqzedddcferzfdsdxvfseffdfgfgfgdgggfvcvxdf%3D%3D.jpg )
2. Upload it

Expected behavior

Frontend should decline the upload wit a info/error popup/message

Installation method

Other Community project

Nextcloud Server version

26

Operating system

None

PHP engine version

None

Web server

None

Database engine version

None

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

No response

Additional info

No response

[sorbaugh]

@skjnldsv do you know by any chance if this this the case in the current version, and if not, is there already a pr somewhere we can backport?

[szaimen]

cc @nextcloud/files

[skjnldsv]

Fixed on master already with #41346, 28 backport in #42591

and additional improvements with #42598