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

Russian characters become question marks
  • Vote Up0Vote Down sunebecksunebeck
    Posts: 3Sendy user

    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?

  • 5 Comments
  • Vote Up0Vote Down BenBen
    Posts: 3,489Sendy support

    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

  • Vote Up0Vote Down sunebecksunebeck
    Posts: 3Sendy user

    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';
    
  • Vote Up0Vote Down BenBen
    Posts: 3,489Sendy support

    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

  • Vote Up0Vote Down sunebecksunebeck
    Posts: 3Sendy user

    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!

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

    Good to hear. Thanks for the query!

This discussion has been closed.
All Discussions