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

            Ascending order - Click to sort in descending order
            jonathan Jonathan Reissmueller created issue -
            jonathan Jonathan Reissmueller made changes -
            Field Original Value New Value
            Rank Ranked higher
            tyson Tyson Phillips (Inactive) made changes -
            Sprint Sprint 1 [ 82 ]
            jonathan Jonathan Reissmueller made changes -
            Remaining Estimate 0 minutes [ 0 ]
            Time Spent 3 hours, 7 minutes [ 11220 ]
            Worklog Id 12382 [ 12382 ]
            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