Search does not support astral (post-BMP) Unicode?

[szc126]

Website (required)

VocaDB

Describe the bug (required)

Searches for post-BMP (emoji, etc.) Unicode characters seem to be nearly equivalent to searching for nothing / listing every song registered in the database.

To Reproduce (optional)

Steps to reproduce the behavior:

1. Go to the Songs page
2. Enter 🥺 (U+1F97A) or 𰻞 (U+30EDE)
3. 522988 song results (as opposed to 522990 results without a search keyword)

Expected behavior (optional)

VocaDB / the VocaDB API returns search results that contain the keyword. Compare https://www.google.com/search?q=🥺+site%3Avocadb.net

Screenshots (optional)

N/A

Desktop (optional)

N/A

Smartphone (optional)

N/A

Additional context (optional)

Add any other context about the problem here.

Checklist (required)

Fill out the checklist. Use strikethroughs or leave fields empty if you don't know or are unable to check/test.

• [x] Searched VocaDB/vocadb for duplicate issues.
• [x] Tested on the beta site.
• [ ] Tested on different browsers (e.g. Firefox, Chrome, Safari, Edge).
• [ ] Checked in private mode.
• [ ] Cleared browser cache and cookies.
• [x] Checked the DevTools console.
• [ ] Checked the syslog (mods+ only).

[FinnRG]

This is a result of the Finnish_Swedish_CI_AS collation. Related to #1618.