Database question regarding collation latin1 vs utf8 vs utf8mb4

[Mr B]

Of course Glenn Vergara , there are no scroll functionality and the "Post" button are grayed out when trying to reply a message. Sending new messages are broken also. The Google Chrome Console...

[Mr B]

Glenn Vergara , we found one issue with the temporary solution. The "Post" button in Message Center/chat do not work on the mobile. Maybe there is a separate template for that? The chat opens...

[Mr B]

Thanks Glenn Vergara ! Your temporary solution seems to work for us.

We are going to migrate the DB to UTF-8 (utf8mb4) but we are facing different type of problems in our test environment...

[Mr B]

Where can i verify if we have a support contract or not? And how do i purchase it if we do not already have it? I cant find the info in "My Account", "Purchase", "Renewals / New...

[Mr B]

But it worked in version 5.4.4 of vBulletin. It stopped working after the upgrade to 5.4.5......

[Mr B]

Thanks for the fast reply.

Where have you attached the scripts needed for converting the database, tables and columns from latin1 to utf8mb4? Can you post them again or give a link to them?...

[Mr B]

We got several unresolved issues with vBulletin 5.4.5 (mostly issues related to special characters like åäö in the swedish language) and the support here have suggested us to convert the MySQL database...

[Mr B]

I got a password for a user who have the problem and logged is as him. The username is "nappaförböveln" and the following two images shows the script errors on our forum home page. Both username...

[Mr B]

How can i find the JSON that you need? For example a user called Gösta experience problems. Will put up a test account with special characters on our site tomorrow.

Something have changed...

[Mr B]

Sorry for that, i discovered this new issue today. Will dig in to it deeper tomorrow morning and will update the other thread with info....

[Mr B]

Do you have version 5.4.5 installed and users with special characters in their usernames?...

[Mr B]

Wayne Luke , can you or other person from the support look at this problem?

[Mr B]

Ok, same here! Do you have language pack installed? I have a swedish one which is partially translated.

It must have slipped in new bugs in 5.4.5. I also had problems with page pagination...

[Mr B]

I think that we got the same issue on our site. Last days three different users (all with special characters like åäö in their user names) have really strange problems... Im at home today but will...

[Mr B]

I have now tested on three different mobiles and one computer with different browsers and the problem seems to be solved. Page pagination works and no errors in the Google Chrome Console. Thanks!
...