Using A= utf8mb4 and changing the table's default charset to the same should work. But yes, using BLOB for the lower_boundary and upper_boundary columns should also work. So far I can't think of why not to use BLOB for these columns and let the connection and result charsets handle interpreting the data.
Heather, Kolbe:
Using A= utf8mb4 and changing the table's default charset to the same should work. But yes, using BLOB for the lower_boundary and upper_boundary columns should also work. So far I can't think of why not to use BLOB for these columns and let the connection and result charsets handle interpreting the data.