I'm working with utf8mb4 databases in MySQL and haven't found a way to set that on the connection. Is there a way? I've tried setting characterEncoding and characterSetResults to utf8mb4, but that gets a non supported encoding error.
If I run "set names utf8mb4" on a connection, it works after that, but it's annoying to have to remember to run that Every. Single. Time.
Is there a way to set utf8mb4 on a connection? Or is there a way to set a script to run on connection start so I can put "set names utf8mb4" on there?