Documentation available for vBulletin application

[Blackhorse]

Hello,

Could you please refer me to any documentation for vBulletin connect that it uses, be that php, perl, rails, etc. to determine how I force it to use UTF-8 as its default character set for all things MySQL related.

Because it is disappointing to see two different tables like this after the effort i did for the same database!

SHOW VARIABLES WHERE variable_name LIKE 'character\_set\_%' OR variable_name LIKE 'collation%';

MySQL:

mysql> SHOW VARIABLES WHERE variable_name LIKE 'character\_set\_%' OR variable_name LIKE 'collation%';
+--------------------------+--------------------+
| Variable_name | Value |
+--------------------------+--------------------+
| character_set_client | utf8mb4 |
| character_set_connection | utf8mb4 |
| character_set_database | utf8mb4 |
| character_set_filesystem | binary |
| character_set_results | utf8mb4 |
| character_set_server | utf8mb4 |
| character_set_system | utf8 |
| collation_connection | utf8mb4_unicode_ci |
| collation_database | utf8mb4_unicode_ci |
| collation_server | utf8mb4_unicode_ci |
+--------------------------+--------------------+
10 rows in set (0.01 sec)


vBulletin:

Variable_name	Value
character_set_client	latin1
character_set_connection	latin1
character_set_database	utf8mb4
character_set_filesystem	binary
character_set_results	latin1
character_set_server	utf8mb4
character_set_system	utf8
collation_connection	latin1_swedish_ci
collation_database	utf8mb4_unicode_ci
collation_server	utf8mb4_unicode_ci

Powered by vBulletin® Versi

[Wayne Luke]

vBulletin doesn't set a default character set. It uses what you have the database configured to use. This can be different from the defaults for the server. The values you're setting aren't necessarily incorrect though. What tables have different character sets?

[Blackhorse]

Hello Wayne,

Thank you for being here. I have changed all tables now -all of them to utf8mb4 and collate utf8mb4_unicode_ci (including all columns)

Now, I am converting them to blob and get them back to utf8 some new texts improved, but all old texts not.

====

How could it be different from the server?

as to my little understanding that the Query in vbulletin is the same as the query in MySQl

The Only Latin i have now is the one in the config file because if i comment it, the whole site gives an error message to contact administrator and not allowing to go anywhere.

Regards,

[Wayne Luke]

Each database has its own character set and collation set. They do not have to be the same as the Server. If you upgraded from older versions of MySQL, it pretty much guarantees that the database and the server settings will be different.

The value in the configuration file tells vBulletin how to talk to the database. Since your vBulletin database is expecting communications in Latin1, you need to specify this. To change this, you'll need to speak to your server administrator.