When I create an export from my entire database, there’s one value which gets changed.
Before export: https://imgur.com/a/iub61
After importing the export: https://imgur.com/a/7lDvZ
I think this has to do with the version of MySQL (which does or does not support emojis), but how can I solve this ?
Even though the values are stored in the db, they don’t show in the admin/front-end.
s2Member doesn’t control the database. You’d do better by asking in a MySQL forum.
ok, then i’ll rephrase my question.
Why isn’t my data outputted, when it’s stored in the db ? Although it changed, the data is still there.
It doesn’t matter how you rephrase the question. Once the data is input to the database, it’s nothing to do with s2Member, and it’s therefore highly unlikely that anyone here will be able to answer.
IMO it does… the data is stored inside the DB with the correct field names. Yet S2member can’t read them. What could cause S2 not being able to read the value even when it’s stored ?
Berry,
It is not an s2Member issue.
The emoticons are not properly encoded during the export, so they show up as question marks ?.
s2Member reads the data from the database, but because the emoticons are not properly encoded, s2Member shows you what is inside the database. In this case, that is a ?.
As Tim suggested earlier, you should check an MySQL forum, or the docs (https://dev.mysql.com/doc/refman/5.7/en/) from MySQL to resolve this.
Thanks Toon…
I can understand the emoticons are not properly encoded during export and in the export they do show up as question marks, correct.
But what I don’t get is that while the emoticons gets changed to ‘?’, the rest of the values remains and should therefor show in my opinion. As you can see in my second screenshot the rest of the data is there, but nothing shows. That wonders me…
Berry,
Or your screenshots are not right, or I just don’t understand.
The data shown on the second screenshot is exactly the same as on the first one, except for the emoticons that are changed to '?'s.
Correct… yet if I edit this user through the change user page (admin side), all values are empty.
I have found the solution… I used Sequel Pro to export my SQL data.
What I didn’t know (until yesterday) is that Sequel Pro can not handle utf8mb4 data (yet).
Version 1.2 will (at least, I’m told it’s announced/promised) but that hasn’t been released yet.
I haven’t gotten PHPMyAdmin to export it properly but I don’t know (yet) if it can handle utf8mb4 and I didn’t investigate since I hardly use it.
The fix is to user adminer to export your database or something else which can handle utf8mb4. Command line probably can but didn’t test.