Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at

  • jivan thapa 192 posts 655 karma points
    Dec 23, 2011 @ 11:33
    jivan thapa

    non english character does not display correctly If I use Mysql Database

    Umbraco verson 4.7.1

    I have one umbraco site that uses MySql Database. Problem is that it does not display correctly Nepalese characters.

    For example I have this character " " it displays correctly in RichText Editor. After I published the content It shows ?????????????????????????????????????????????????????????????????????????????? in webpage. but it displays correctly in RichText Editor.

    I also checked Tidy is set to Utf8.


    I have also another website that uses MSSQL Database. it works perfectly on that website. Problem is if i use MySql Database.

    Here is XSLT

    <?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE xsl:stylesheet [ <!ENTITY nbsp "&#x00A0;"> ]>
      xmlns:umbraco.library="urn:umbraco.library" xmlns:Exslt.ExsltCommon="urn:Exslt.ExsltCommon" xmlns:Exslt.ExsltDatesAndTimes="urn:Exslt.ExsltDatesAndTimes" xmlns:Exslt.ExsltMath="urn:Exslt.ExsltMath" xmlns:Exslt.ExsltRegularExpressions="urn:Exslt.ExsltRegularExpressions" xmlns:Exslt.ExsltStrings="urn:Exslt.ExsltStrings" xmlns:Exslt.ExsltSets="urn:Exslt.ExsltSets" 
      exclude-result-prefixes="msxml umbraco.library Exslt.ExsltCommon Exslt.ExsltDatesAndTimes Exslt.ExsltMath Exslt.ExsltRegularExpressions Exslt.ExsltStrings Exslt.ExsltSets ">
    <xsl:output method="xml" omit-xml-declaration="yes"/>
    <xsl:param name="currentPage"/>
    <xsl:template match="/">
    <!-- start writing XSLT -->
     <div class="sub-content-wrapper">
       <div class="content_border"
         <h3>  <xsl:value-of select="$currentPage/contentTitle"/></h3
          <xsl:if test="string-length($currentPage/contentImage)&gt;1">
            <img src="{$currentPage/contentImage}" width="600px"/>
         <xsl:value-of select="$currentPage/contentBody" disable-output-escaping="yes"/>    

    Any suggestions?





  • Jan Skovgaard 10761 posts 21144 karma points MVP 4x admin c-trib
    Dec 23, 2011 @ 12:45
    Jan Skovgaard

    Hi Jivan

    I think it has to do with the character set i MySQL. It's related to MySQL not Umbraco itself I think. It seems like it maybe has to do with the tables being created with a character set based on latin1 instead of utf8.

    You can read more about it here: and here

    I hope this helps.


Please Sign in or register to post replies

Write your reply to: