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.
| expression Data Type | Server Character set of Resulting Characters |
|---|---|
| Noncharacter | User default server character set |
| Character | Server character set of expression |