Get answers quicker by searching

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

Chinese characters broken after upgrading 1.1.6
  • Vote Up0Vote Down hkocerhkocer
    Posts: 1Sendy user

    all characters are broke after upgraded to 1.1.6 version, I am not able to read and write any Chinese words. Any clue on that? pls help !!!!

    http://edm.unwire.hk/sendy.png

  • 8 Comments
  • Vote Up0Vote Down BenBen
    Posts: 3,484Sendy support

    Hi,

    In 1.1.6, the character set for the database is set to UTF8 whenever Sendy connects to the database.

    Can you check your database directly via phpmyadmin to see how the chinese characters are displayed?

    Thanks.

    Ben

  • Vote Up0Vote Down edwongedwong
    Posts: 1Sendy user

    i have the same problem. after upgraded to 1.1.6, all chinese characters are broken. please help

  • Vote Up0Vote Down BenBen
    Posts: 3,484Sendy support

    Hi @edwong,

    In 1.1.6, the character set for the database is set to UTF8 whenever Sendy connects to the database.

    Can you check your database directly via phpmyadmin to see how the chinese characters are displayed?

    Thanks.

    Ben

  • Vote Up0Vote Down edwongedwong
    Posts: 1Sendy user

    no phpmyadmin. but in 1.1.5, it's working fine. so should be coding problem. any chance you can send us the 1.1.5 version? we need to fix this problem soon. thx (i emailed you about 30 mins ago)

  • Vote Up0Vote Down BenBen
    Posts: 3,484Sendy support

    Hi @edwong @hkocer

    I investigated this further and realized chinese characters uses utf16. Sendy sets the character set to utf8 by default in 1.1.6.

    I've added a fix in 1.1.6 so that you can set the character set to utf16 to display chinese characters. Please re-download Sendy at http://sendy.co/get-updated and re-upgrade your current installation.

    Then include the following line in your /includes/config.php file right after define('COOKIE_DOMAIN', '');

    $charset = 'utf16';

    Sendy will use utf16 which will in turn write and retrieve chinese characters correctly from the database.

    Thanks.

    Ben

  • Vote Up0Vote Down edwongedwong
    Posts: 1Sendy user

    great. thx ben. all pages works now, except the previous email subject line (in report page and campaign page) is still wrong. user name and email subject in campaign detail page works fine.

  • Vote Up0Vote Down edwongedwong
    Posts: 1Sendy user

    figured out why. in the code, just htmlentities($row['title'],ENT_QUOTES,"UTF-8") (do not just use htmlentities($row['title'])

  • Vote Up0Vote Down BenBen
    Posts: 3,484Sendy support

    Thanks @edwong, I've updated the build with ENT_QUOTES flag for the htmlentities method.

This discussion has been closed.
All Discussions