Problem with special characters VB5

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • malder
    New Member
    • Feb 2012
    • 26
    • 4.1.x

    Problem with special characters VB5

    Hello, my problem is that I made a migration from version 4, and I have many problems with special characters like accents and others.

    The language is Spanish and can see an example in the following url

    http://www.foroz.org/foroz/forum/inf...able-en-google

    But the forum if it is, though not so messages

    http://www.foroz.org/foroz/forum/inf...s-informáticos

    I have read a lot of documentation and tested in different ways using utf html and activating the config file line

    $config['Mysqli']['charset'] = 'utf8';

    With this last line forum stops working completely

    Later I followed instructions in the documentation by running a query:

    SHOW VARIABLES LIKE 'char%'

    and the result is:
    character_set_client latin1
    character_set_connection latin1
    character_set_database utf8
    character_set_filesystem binary
    character_set_results latin1
    character_set_server latin1
    character_set_system utf8
    character_sets_dir /usr/share/mysql/charsets/
    as you can see the problem should be there, to have different character code to perform the steps to solve this by creating the file and indicating in the config file the line:

    $config['Mysqli']['ini_file'] = realpath('./../../mysqli.ini');

    $config['Mysqli']['ini_file'] = '/httpdocs/foroz/mysqli.ini';

    or

    $config['Mysqli']['ini_file'] = 'mysqli.ini';

    but did not work, the problem must be in the difference in coding? I hope can help me since my system is throwing errors and many issues are not accessible right now

    sorry for my English ...
    Last edited by malder; Sun 24 Nov '13, 3:26pm.
  • Wayne Luke
    vBulletin Technical Support Lead
    • Aug 2000
    • 73981

    #2
    You should only use one character set and collation across your entire system. You'll need to convert your tables and records to UTF-8. If you don't know how to do this, you can consult your hosting company and they can make the changes for you.
    Translations provided by Google.

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

    Comment

    • malder
      New Member
      • Feb 2012
      • 26
      • 4.1.x

      #3
      expected a more detailed help to solve this problem myself, my hosting server does not support this service

      you could give me more clues to achieve fix this?

      Comment

      • Omeka
        Senior Member
        • Jul 2004
        • 427
        • 5.7.0

        #4
        1. Open the phpMyAdmin interface
        2. Click on the name of the database to be modified
        3. Click on SQL
        4. Add this query to change the character set to utf-8:

        ALTER DATABASE CHARACTER SET utf8 COLLATE utf8_general_ci;
        Last edited by Omeka; Mon 25 Nov '13, 3:02pm.
        https://traduzioni-italiane.it/

        Comment

        • malder
          New Member
          • Feb 2012
          • 26
          • 4.1.x

          #5
          Originally posted by Omeka
          1. Open the phpMyAdmin interface
          2. Click on the name of the database to be modified
          3. Click on SQL
          4. Add this query to change the character set to utf-8:
          Hello I ran that query, the answer was accepted successfully but the problem with the characters remains the same

          Comment

          • malder
            New Member
            • Feb 2012
            • 26
            • 4.1.x

            #6
            any other ideas? or it may be a bug in vbulletin?

            Comment

            • Omeka
              Senior Member
              • Jul 2004
              • 427
              • 5.7.0

              #7
              No veo errores en su idioma español, también leí algunas discusiones. Me haría un ejemplo?


              I do not see errors in your Spanish language, I also read some discussions. It would make me an example?
              https://traduzioni-italiane.it/

              Comment

              • malder
                New Member
                • Feb 2012
                • 26
                • 4.1.x

                #8
                if I can give several examples, the problem now accessing forums working properly but not working topics with access to special characters.

                as such



                Comment

                • malder
                  New Member
                  • Feb 2012
                  • 26
                  • 4.1.x

                  #9
                  the problem is not the language
                  the problem is the special characters in the url address, makes many of the topics are not accessible

                  Comment

                  • Omeka
                    Senior Member
                    • Jul 2004
                    • 427
                    • 5.7.0

                    #10
                    Check the .htaccess file and sitemap.
                    https://traduzioni-italiane.it/

                    Comment

                    • malder
                      New Member
                      • Feb 2012
                      • 26
                      • 4.1.x

                      #11
                      hello, htaccess file is uploaded again from the download package

                      I replaced but nothing changes

                      sitemap not activated

                      Comment

                      • Omeka
                        Senior Member
                        • Jul 2004
                        • 427
                        • 5.7.0

                        #12
                        I think it's a problem of rewriting.
                        https://traduzioni-italiane.it/

                        Comment

                        • ralph.jaeger
                          New Member
                          • Jun 2014
                          • 10
                          • 5.0.X

                          #13
                          same problem in german. All tables are utf8. But URLs look weird.

                          Comment

                          Related Topics

                          Collapse

                          Working...