Search custom index: log_search_words not built in correct collation

[sbulen]

Description

log_search_words is built in the DB default collation, not utf8mb3_general_ci to match the rest of SMF tables.

Steps to reproduce

1. Create a new DB with a default collation latin1_swedish_ci
2. Install vanilla 2.1
3. Build a custom search index; its collation will be latin1_swedish_ci

Environment (complete as necessary)

• Version/Git revision: current
• Database Type: mysql
• Database Version: 8.0
• PHP Version: 8.2

[albertlast]

should be a mysql only issue

[sbulen]

Yep

[jdarwood007]

Possibly unrelated. But I have a forum that is failing to upgrade to UTF-8 because of this table. I have to change the words column to varchar(80) to get the upgrade to complete.

[sbulen]

@jdarwood007 - Note that there are no text columns in this table, so I think your utf8 conversion failing is due to another table.

My suspicion is your error was with log_search_subjects, and that what you saw is a dupe/alt symptom of #6405 ... Still need to properly get to mb4 (#6409 ).