We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 10076
    • 1,024 Posts
    Hi, not sure if this is the correct board.
    I am having problems correctly displaying characters.
    The best example is Antonín Leopold Dvořák.
    His name gets displayed with little rectangles, question marks and the likes.
    In phpmyadmin all seems to be okay, just the pages diplay it different.
    Now there is the "stuff" in the header of my page:

    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
        "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
    <head>
      <meta http-equiv="content-type" content="text/html; charset=utf-8" />


    And I can assign a collation to the database/table/field, plus set one in MODX. Plus use field type of VARCHAR or TEXT. As we say in Dutch I dont see the forest through the trees. Translated, I am lost here. How can I make sure that Mr Dvořák ’s name gets diplayed with all the accents?
      • 22303 MODX Staff
      • 10,725 Posts
      Well first, since you are telling the browsers that you are serving utf-8 content, your database needs to use a collation that begins with utf8_ (i.e. utf8_general_ci or utf8_unicode_ci, etc.). In fact, your database needs to be created with the proper collation before you even install MODx or you will likely get the MySQL default of latin1_swedish_ci which is not a utf8 compatible encoding, and all of the tables will be created with the wrong collation. At that point you would have to manually alter every text/varchar column in your database to change to a utf8_ collation successfully; just altering the database container is not enough.
        • 10076
        • 1,024 Posts
        SO in the future just use the modx default latin1_swedish_ci would suffice?
        Would that display r with tilde (Dvořák ) correct?