I have been ripping my hair out trying to get my Golang API to parse a MySQL database columns through gorm and have gotten nowhere when it comes to the entries that have foreign language values. There doesn’t seem to be any guides on this anywhere online so I’m hoping I can get some help here.
I’ve got a database that has many tables containing Japanese characters. For example, I have this string in one of the rows:
However, when doing a SELECT on the database for this entry that has this text value, it keeps coming back as:
I’ve ensured the database is correctly created with utf8mb4 and even have this particular column set with
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci on the table. For my call to
gorm.Open, I’ve set the following parameters at the end to ensure that it’s parsing utf8mb4:
How can I get Golang to support UTF8 properly when the database is properly set?
If it helps, here’s the UTF8 is in the database as expected:
mysql> select alt_text from picture_details where id=136; +--------------+ | alt_text | +--------------+ | 美味しい | +--------------+ 1 row in set (0.00 sec)
And yes, I’ve tried to change the text to a manually encoded string of
xe7xbex8exe5x91xb3xe3x81x97xe3x81x84 just to see if that’d resolve it (it didn’t).