Character set conversion has been added to translate strings automatically between different character sets as data is passed between client applications and the database server. This enables more flexibility in mixed character-set environments.
Character set conversion can be carried out among character sets that represent the same characters, but at different values. There needs to be a degree of compatibility between the character sets for this to be possible. For example, character set conversion is possible between EUC-JIS and Shift-JIS character sets, but not between EUC-JIS and OEM code page 850.
To enable character-set conversion, you must start the database server using the new -ct option.
Most of the character set conversion features occur automatically, with little user intervention required.
For a description of character set conversion, see Character set conversion.