We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 9995
    • 1,613 Posts
    I'm trying to get this character on my Evo 1.0.5 website: ō

    Html code: & #x14D;

    Somehow TinyMce makes it a: ? after saving, even when i paste it into the html of TinyMce.
    The insert symbol doesn't have this character. It's a Japanese character.

    Anyone knows a solution? Is it possible to add this into the insert symbol table? Do i need to change the theme of the TinyMCE settings?

    [ed. note: fourroses666 last edited this post 14 years, 6 months ago.]
      Evolution user, I like the back-end speed and simplicity smiley
      • 28042 ☆ A M B ☆
      • 24,524 Posts
      What is the character set of your database?
        Studying MODX in the desert - http://sottwell.com
        Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
        Join the Slack Community - http://modx.org
        • 28042 ☆ A M B ☆
        • 24,524 Posts
        You might want to go to the Configuration tab of TinyMCE and select "raw" from the Entity Encoding field.
          Studying MODX in the desert - http://sottwell.com
          Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
          Join the Slack Community - http://modx.org
          • 9995
          • 1,613 Posts
          Hmm, the raw didn't work,

          I see some coalition: latin1_swedish_ci

            Evolution user, I like the back-end speed and simplicity smiley
            • 28042 ☆ A M B ☆
            • 24,524 Posts
            That will be a problem. Unless you're using UTF8 or a specific Japanese character set it can't be saved. It'll just show garbage or ?
              Studying MODX in the desert - http://sottwell.com
              Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
              Join the Slack Community - http://modx.org
              • 9995
              • 1,613 Posts
              I think i can solve the problem laugh

              I have a website where i already changed the coalition into UTF-bin (for chinese language).
              After testing it seems to work.

              Need to change the coalition, thought it was specific japanese but isn't actually.

                Evolution user, I like the back-end speed and simplicity smiley
                • 3749
                • 24,544 Posts
                The instructions here are for switching to UTF-8 (which might solve your problem), but you can use them to switch to any character set/collation: http://bobsguides.com/convert-db-utf8.html


                ---------------------------------------------------------------------------------------------------------------
                PLEASE, PLEASE specify the version of MODX you are using . . . PLEASE!
                MODX info for everyone: http://bobsguides.com/modx.html
                  Did I help you? Buy me a beer
                  Get my Book: MODX:The Official Guide
                  MODX info for everyone: http://bobsguides.com/modx.html
                  My MODX Extras
                  Bob's Guides is now hosted at A2 MODX Hosting
                  • 9995
                  • 1,613 Posts
                  I have changed all to utf8 only the table which needs to be changed i get an error.

                  modx_site_content table: (content, pagetitle and description)

                  SQL-query:
                  
                  ALTER TABLE `modx_site_content` CHANGE `content` `content` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
                  
                  MySQL retourneerde: Documentatie
                  #1283 - Column 'content' cannot be part of FULLTEXT index 


                  Fulltext is not a (type) option.

                    Evolution user, I like the back-end speed and simplicity smiley
                    • 3749
                    • 24,544 Posts
                    Fourroses666, did you follow all the steps at the link I provided?

                    I've seen that error, but it's been so long that I can't remember what the solution is.


                    ---------------------------------------------------------------------------------------------------------------
                    PLEASE, PLEASE specify the version of MODX you are using . . . PLEASE!
                    MODX info for everyone: http://bobsguides.com/modx.html
                      Did I help you? Buy me a beer
                      Get my Book: MODX:The Official Guide
                      MODX info for everyone: http://bobsguides.com/modx.html
                      My MODX Extras
                      Bob's Guides is now hosted at A2 MODX Hosting
                      • 28042 ☆ A M B ☆
                      • 24,524 Posts
                      Perhaps you could remove the FULLTEXT index (it's made up of pagetitle, description and content), alter the table, then re-create the index.

                      Looking at this, I have to wonder why description? I would think that longtitle and introtext would be much more useful.
                        Studying MODX in the desert - http://sottwell.com
                        Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
                        Join the Slack Community - http://modx.org