MariaDB character set and collation recommendations

[Richard Frovarp]

On 7/18/22 16:12, Cantor, Scott via users wrote:
> On 7/18/22, 5:02 PM, "users on behalf of Wessel, Keith via users" <users-bounces at shibboleth.net on behalf of users at shibboleth.net> wrote:
>
>> My development instance is using utf8mb4, and I just changed its collation from utf8mb4_general_ci to
>> utf8mb4_bin. This seems like a reasonable choice, but I'd like to ask for the widom of others on the list who
>> might be willing to share.
> I believe (and the code certainly backs me up) that we operate strictly in the Java String sphere and the driver has to be able to convert, so you at minimum need something able to encode any Java String value, or live with the issues that might happen if you don't. Any UTF-8 encoding is probably fine, but I don't know what those all mean.
>
> -- Scott
>
>
For other projects, we use utf8mb4 as the charset and utf8mb4_bin as the 
collation.