Converting MySQL database to UTF16

Question

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

Its shows only UTF8 alongwith some other character sets. Any idea about how to upgrade it if its the case Thanks — Yoosuf, Jun 17 '12 at 08:22

score 6 · Accepted Answer · answered Jun 17 '12 at 08:37

6

The utf16 character set is available since MySQL 5.5 and up.
I guess you're using some earlier version.

answered Jun 17 '12 at 08:37

deceze

510,633
85
743
889

Thanks for the link but I cant find a download link there – Yoosuf Jun 17 '12 at 08:50
How to best upgrade your installation very much depends on your system. But the official downloads are all here: http://dev.mysql.com/downloads/mysql/ – deceze Jun 17 '12 at 09:13

Converting MySQL database to UTF16

1 Answers1