Russian characters become question marks

sunebeck · June 2013

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?

Ben · June 2013

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

sunebeck · June 2013

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';

Ben · June 2013

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

sunebeck · 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!

Ben · June 2013

Good to hear. Thanks for the query!

Russian characters become question marks

Comments