How to see special characters in MySQL Workbench query results?
I doubt if there is an easier way than that CONCAT to see the spaces.  (And that will fail for various esoteric characters.)

Here's another way; it is more practical for more complex situations:

SELECT HEX(`code`) ...


It will return 465220. for "FR ".

Declare it this way:

code CHAR(2) CHARACTER SET ascii NOT NULL


The (2) will truncate to 2 characters (perhaps with a warning); the rest is appropriate for a "country code" column.

(When asking questions, specify MySQL version.)