Very helpful.
I didn't know that UTF8MB4 is native to MySQL.
Is this also supported on PostgreSQL ?
There can be a usecase of MySQL to PostgreSQL migration. Just a thought.
since MySQL's version of UTF-8 is actually 1 to 3 bytes, and hence they provide
UTF8MB4 (1 to 4 bytes), the postgreSQL UTF8 should work fine without any issues.
From UTF8MB4 to UTF8, but this is an ideal situation, will have to simulate
this scenario to actually be able to provide some insights and if it would work
as expected.
Meanwhile, for some useful links:
https://www.postgresql.org/docs/9.3/multibyte.html
https://www.postgresql.org/message-id/201503051745459170125%40pconline.com.cn
Warm regards
Ragini
