Arrowchat + Vbulletin encoding issue
 

I've vbulletin 4.2.0, where arabic usernames are written to mysql in wrong chars but vb displays them correctly.

last week I added arrowchat, where they display them like how they are written into database.

Their support don't want to support me in this unless I give them FULL access to my database + full access to the file manager (to fix encoding in arrowchat files)

I asked why they want that, and provided FTP to their arrowchat directory but refused to help without accessing my database and vb files !!!!!

anyone faces such issue and know how to fix it? + I started to have doubts in arrowchat support who are not reasonable and asking for full access to a customer db ! (the weirdest request ever):mad:

To change the utf8mb4 character encoding in the config.php file, you need ftp access.

Hello,
Of course it needs ftp access, and that what I provided to them FTP access to arrowchat directory but they refused and asked for the full access to vb + arrowchat + phpmyadmin !!

Anyway they can tell me which encoding I need to make it works (change the utf8 to what), as they refuse to tell me ! also I tried many other encodings but not working.

https://i.postimg.cc/7bYDMvDB/screen...4-18-51-23.png

Identifies arabic letters if you save the comparison setting for phpMyAdmin arrowchat tables as utf8_unicode_ci or utf8mb4_unicode_ci

It is enough to change the comparison of the names and texts in which field.

the table is already utf8_unicode_ci
https://www5.0zz0.com/2020/12/26/00/809006552.png


the user is shown like this as created by vbulletin 4.2.0
https://www5.0zz0.com/2020/12/26/00/492007582.png

Vbulletin convert it and shows it correctly in my forum but Arrowchat showing it as is.

Change the table to utf8mb4 as well, doubt that will fix it.

The arrowchat code may be incorrect as well.

no it won't..
Arrowchat the worst support ever.

What version of vBulletin (if 4, then 4.2.1 or 4.2.3 etc) and what version of the mod are you using? You could possibly be using a mod version not compatible with your version of vBulletin.

If there is a thread here for this mod, you should post there asking for assistance as well.