Announcement

Collapse
No announcement yet.

Documentation available for vBulletin application

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Documentation available for vBulletin application

    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




  • #2
    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?

    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment


    • #3
      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,

      Comment


      • #4
        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.
        Translations provided by Google.

        Wayne Luke
        The Rabid Badger - a vBulletin Cloud demonstration site.
        vBulletin 5 API

        Comment

        Related Topics

        Collapse

        Working...
        X