CODEWITHSUNDEEP
mysqlsetcharacterutf-16
Yoosuf
Yoosuf

Reputation: 892

Converting MySQL database to UTF16

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

Upvotes: 4

Views: 8959

Answers (1)

deceze
deceze

Reputation: 522081

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

Upvotes: 6

Related Questions