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.
<TidyEditorContent>True</TidyEditorContent>
<TidyCharEncoding>UTF8</TidyCharEncoding>
I have also another website that uses MSSQL Database. it works perfectly on that website. Problem is if i use MySql Database.
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.
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
Any suggestions?
thanks
Jivan
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: http://alexking.org/blog/2008/03/06/mysql-latin1-utf8-conversion and here http://www.bluebox.net/news/2009/07/mysql_encoding
I hope this helps.
/Jan
is working on a reply...