When data_definition_list specifies a data type of CHARACTER (CHAR) or CHARACTER VARYING (VARCHAR) and does not specify a CHARACTER SET clause to indicate which server character set to use, then the resulting server character set is as follows.
IF the data type of expression is … | THEN the server character set of the resulting characters is … |
---|---|
non-character | the user default server character set. |
character | the server character set of expression. |