Skip to content

Russian characters become question marks

edited June 2013 in Troubleshooting

A fresh install of Sendy will create latin1 tables and databases, it seems, so I understand why it cannot store cyrillic characters. Is there a way to make it use utf8?

Can I trust that cyrillic emails will be sent with the correct encoding, and be readable in the different mail clients?

Comments

  • Hi @sunebeck,

    The latest build that can be downloaded at http://sendy.co/get-updated now creates tables in utf8.

    If you can do a fresh install now with all the existing tables removed, your tables will all be created in utf8. Otherwise, try setting the $charset in /includes/config.php to utf16.

    Thanks.

    Ben

  • I just installed it the day before yesterday, and it seems to be 1.1.6.3, the newest version. Any reason they could still have been created as latin1? config.php contains:

    $charset = 'utf8';
    
  • Hi @sunebeck,

    I just downloaded 1.1.6.3 from http://sendy.co/get-updated and installed it on an empty database, the tables are all utf8 instead of latin1 though.

    Can you try again on an empty database (download 1.1.6.3 from http://sendy.co/get-updated)?

    Thanks.

    Best regards,
    Ben

  • edited June 2013

    Okay, weird that it chose latin1 on mine. Perhaps it inherited the database's character set.

    I ran this on the existing installation to convert all the tables:

    mysql --database=dbname -B -N -e "SHOW TABLES" \
    | awk '{print "SET foreign_key_checks = 0; ALTER TABLE", $1, "CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; SET foreign_key_checks = 1; "}' \
    | mysql --database=dbname &
    

    Afterwards it seems to work!

  • Good to hear. Thanks for the query!

This discussion has been closed.