Re: Solution for Unknown OS character set 'ISO-8859-15'

[Rick James]

MySQL does not call them by their ISO names.
SHOW COLLATION LIKE 'latin%';
shows latin1, latin2, latin7 in the version I am running.
-15 is perhaps "latin9", which does not seem to be implemented.

My advice -- Use ascii and utf8/utf8mb4, nothing else.

You can have the client encoding different than the column definitions. See SET NAMES and SHOW VARIABLES LIKE 'char%'; However, you would need to pick latin1/2/7, not 9. What specific characters will you need? Maybe one of those will suffice. (utf8 will definitely have all the European characters, including Greek and Cyrillic.)