Uploaded image for project: 'Blesta Extensions'
  1. Blesta Extensions
  2. EXT-7

Characters converted to ? when inserted into the database

        Details

        • Type: Bug
        • Status: Open
        • Priority: Major
        • Resolution: Unresolved
        • Component/s: None
        • Labels:
          None

          Description

          For some languages (e.g. Hebrew), the characters entered for a language definition will be converted to question marks when inserted into the database. To reproduce:

          • Select Hebrew as your language and random as your order
          • Use php my admin to find the "term_id" of the text you are translating in the "definitions" table
          • Enter the Hebrew translation and submit (You can get it from google translate)
          • Find all records in the table with the "term_id" you found
          • See the Hebrew one is question marks

            Activity

            Hide
            Permalink
            jonathan Jonathan Reissmueller added a comment -

            Updating the collation of the live database fixed this issue.
            Looks like we may also want to update the database.php to change the character set query from:
            "charset_query"=>"SET CHARACTER SET 'utf8'",
            to:
            "charset_query"=>"SET NAMES 'utf8'",

            Show
            jonathan Jonathan Reissmueller added a comment - Updating the collation of the live database fixed this issue. Looks like we may also want to update the database.php to change the character set query from: "charset_query"=>"SET CHARACTER SET 'utf8'", to: "charset_query"=>"SET NAMES 'utf8'",

              People

              • Assignee:
                jonathan Jonathan Reissmueller
                Reporter:
                jonathan Jonathan Reissmueller
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 3 hours, 7 minutes
                  3h 7m

                    Agile