Im starting to be desperate here... I cant get the search working with Swedish characters like åäö. For example Swedish fish names like gädda, gös, färna. But no words at all with Swedish characters are searchable. The words show up fine in the forum but the search index removes all Swedish characters. So, in the "words" database table the fish names are stored like "gdda", "gs" and "frna" instead of their correct names. This worked very well in version 4.2.5 but not in version 5.4.4. This must be fixed!
Some server info:
Windows Server 2016 with IIS 10
PHP 7.2.7 (default charset iso-8859-1)
MySQL 5.7.20 (character set "latin1" and collation "latin1_swedish_ci")
vBulletin info:
vBulletin 5.4.4
Seach type is "DB Search"
Swedish language pack installed
I have tried loads of different settings in separate testvb environments and i cant getting it to work…
- Ive tried to do several fresh installs of 5.4.4 with different character sets (both for PHP and also in MySQL). For example ive tried utf8 and utf8mb4 with the same problem.
- Ive tried to install Sphinx search engine with no luck.
- Ive tried different language settings for the Swedish language pack with no luck.
The same issue seems to be here at vBulletin forum. Try to search for "gädda" for example. Will find nothing… try to seach for "gdda" and you will find this thread.
Why is the åäö characters removed when rebuilding the search index? What settings are affecting which characters are included when the rebuild search index is performed? Why do the database table "words" missing the Swedish characters? Also when creating new threads the åäö is removed when the words is placed in the "words" table in the database.
As i mentioned before, this worked like a charm in vBulletin 4.2.5 and after the upgrade to 5.4.4 it stopped working… please help with this! I cant solve it by myself.
Some server info:
Windows Server 2016 with IIS 10
PHP 7.2.7 (default charset iso-8859-1)
MySQL 5.7.20 (character set "latin1" and collation "latin1_swedish_ci")
vBulletin info:
vBulletin 5.4.4
Seach type is "DB Search"
Swedish language pack installed
I have tried loads of different settings in separate testvb environments and i cant getting it to work…
- Ive tried to do several fresh installs of 5.4.4 with different character sets (both for PHP and also in MySQL). For example ive tried utf8 and utf8mb4 with the same problem.
- Ive tried to install Sphinx search engine with no luck.
- Ive tried different language settings for the Swedish language pack with no luck.
The same issue seems to be here at vBulletin forum. Try to search for "gädda" for example. Will find nothing… try to seach for "gdda" and you will find this thread.
Why is the åäö characters removed when rebuilding the search index? What settings are affecting which characters are included when the rebuild search index is performed? Why do the database table "words" missing the Swedish characters? Also when creating new threads the åäö is removed when the words is placed in the "words" table in the database.
As i mentioned before, this worked like a charm in vBulletin 4.2.5 and after the upgrade to 5.4.4 it stopped working… please help with this! I cant solve it by myself.
Comment