JSON_OBJECT can't handle emoji

[kaihendry]

https://media.dev.unee-t.com/2019-05-21/emoji-test.sh is a test that confirms this.

Perhaps encoding first/last name in base64 is a good workaround? https://dev.mysql.com/doc/refman/8.0/en/string-functions.html#function_to-base64
In the lambda I can base64 decode.

I've raised the issue with AWS https://console.aws.amazon.com/support/cases#/6092011631/en

[kaihendry]

I asked AWS support about this in CASE 6092011631 and they replied:

In regards to your query "Can you confirm if this JSON_OBJECT bug has been fixed in aurora? https://stackoverflow.com/questions/45932774/mariadb-json-object-bad-encoding"

Yes this works well in Aurora Mysql and I have tested it, please note JSON is only supported in Aurora which is Mysql version 5.7 compatible.

[kaihendry]

Btw I've followed up again with my test case asking them to prove I'm not losing my mind.

[kaihendry]

Closing this duplicate to focus upon #73 (comment)