Announcement

Collapse
No announcement yet.

wrong characters for romanian after upgrade to 5.6.5

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

  • wrong characters for romanian after upgrade to 5.6.5

    Could this be related to the DB that have latin collation instead of UTF-8?
    See attached images for the settings in Language and the error.

  • #2
    What are the collations on your database tables?

    Is the following line in your core/includes/config.php file commented out or not - and if it is, what's the value for this?:

    // $config['Mysqli']['charset'] = 'utf8';
    Vote for:

    - *Admin Settable Paid Subscription Reminder Timeframe*
    -
    *PM - Add ability to reply to originator only*
    - Add Admin ability to auto-subscribe users to specific channel(s)
    - "Quick Route" Interface...

    Comment


    • #3
      the line is commented:
      // $config['Mysqli']['charset'] = 'utf8';

      My forum DB has both UTF-8 and latin tables:

      Comment


      • #4
        You will need to change your Locale to a UTF-8 Locale. It should be ro_RO.utf8 but verify that with your hosting provider as they will be the only ones who know what locales they have installed on the server.
        Translations provided by Google.

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

        Comment


        • #5
          I changed locale to ro_RO.utf8 after I spoke with my Hosting provider.
          Unfortunately I have another kind of wrong character (missing characters). If I want to correct them manually then the error will appear if I choose English language.
          Because English has HTML character set ISO-8859-1 .

          Maybe the solution is to convert DB to UTF-8 so I will be able to set also English to UTF-8?

          Comment


          • #6
            ISO-8859-1 is a subset of UTF-8 characters specifically tuned to the English language. The HTML Character Set is not related to the database. It only tells the browser how to display characters. You should be able to change this to UTF-8 for English. All new installs and our language packs for English are currently using UTF-8.
            Translations provided by Google.

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

            Comment


            • #7
              Hello, I notice that users that have English language set on the forum are not affected . Can I change the language to English for all users by a MySql (PHPMyAdmin) query?
              I don't want to delete Romanian language completely because I made a lot of changes in the translation and I don't want to loose it. Maybe later I can find a solution to use again Romanian.

              Comment


              • #8
                UPDATE user SET languageid=X;

                where X is the ID of the language (you can get this from the admin CP).
                Vote for:

                - *Admin Settable Paid Subscription Reminder Timeframe*
                -
                *PM - Add ability to reply to originator only*
                - Add Admin ability to auto-subscribe users to specific channel(s)
                - "Quick Route" Interface...

                Comment

                Related Topics

                Collapse

                Working...
                X