MySQL encoding only works on localhost

Asked Jan 25 '18 at 00:57

Active Jan 25 '18 at 00:57

Viewed 49 times

I have a PHP script which saves some data into a MySQL db using PDO.

On my Mac, I am using MAMP which is running PHP 7.1 and MySQL 5.6.35. On my VPS, I am using apache2 which is running PHP 7.0 and MySQL 5.7.

I imported the exact database sql file to my remote server as I have locally, however I am facing some problems with encoding.

Locally, everything gets saved nicely into the database. On my remote however, a lot of non-latin characters show up as random symbols. As mentioned above, the remote database uses the same encoding as the local database. I am guessing it is a problem on the PHP side.

EDIT: I am trying to save some Hungarian text if that helps.

Any ideas?

Thanks

asked Jan 25 '18 at 00:57

Balázs Vincze

3,550
5
29
60

Run `SHOW TABLE STATUS` command on both databases to see what is the table collation. – Felippe Duarte Jan 25 '18 at 01:00
They match exactly. utfmb_unicode_ci – Balázs Vincze Jan 25 '18 at 01:01
Run `SELECT default_character_set_name FROM information_schema.SCHEMATA WHERE schema_name = "schemaname";` to see the schema charset – Felippe Duarte Jan 25 '18 at 01:03
Thanks for the tip. I checked it and the remote one was latin1. I created a new database with utf-8, but still no success... – Balázs Vincze Jan 25 '18 at 12:36
See "Best Practice" in https://stackoverflow.com/questions/38363566/trouble-with-utf8-characters-what-i-see-is-not-what-i-stored – Rick James Jan 26 '18 at 16:15
Setting it to utf-8mb4 solved it for me, thanks! It's weird though because on localhost, it works even with utf-8. – Balázs Vincze Jan 26 '18 at 17:00

MySQL encoding only works on localhost

0 Answers0