Re: How to use UTF16 with .net

[Fernando Gonzalez Sanchez]

Correct,

This is a bug in Connector/NET, I opened a bug here: http://bugs.mysql.com/bug.php?id=69169

For the record both UTF16 and UTF32 are broken.

Workaround is to use UTF8mb3/UTF8mb4/UTF8.
like alter table actor convert to character set utf8mb4

The actual fix is very simple, adding a line
mapping.Add("utf16", new CharacterSet("utf-16BE", 2));
(if you want to rebuild the source yourself).

to method MySql.Data.MySqlClient.CharSetMap.LoadCharsetMap.

This fix should appear in next Connector/NET maintenance release.

Thanks for your bug report.