Converting MySQL database to UTF16
character, mysql, set, utf-16
Solution
The `utf16` character set is available since MySQL 5.5 and up. I guess you're using some earlier version.
Problem
I am trying to create this table in a MySQL database ``` CREATE TABLE IF NOT EXISTS `Scania` ( `GensetType` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `EngineType` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `Engine60Hz` int(11) NOT NULL, `Alternator` text CHARACTER SET utf16 COLLATE utf16_unicode_ci NOT NULL, `PriceEur` float NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; ``` However I receive a error message as ``` Error 1115 <42000> : Unknown character set: 'UTF 16' ``` I even tried to Alter the database but I received the same error ``` ALTER DATABASE nordhavn charset='utf16' ``` I tried searching online about other methods to convert the database but failed to find any possible solutions