Re: byte[] to binary(16) throwing IndexOutOfRangeException

[Firstiar Noorwinanto]

So... Three weeks and no one know why this is happen?

According to the stack traces, the exception was thrown at MySql.Data.Types.MySqlBinary.EscapeByteArray(Byte[] bytes, Int32 length, MySqlPacket packet). If I not mistaken, this should be escaping byte value of 0 (a.k.a 0x0 a.k.a '\0') and any of \\, \', or \" by adding additional '\' before them. The question is, why do we need these escapes?

If the escapes is the intended behavior, is there any way for me to store an exact 16 bytes of array into mysql's binary(16) or varbinary(16)? I can't use bigint since it's only use 8 bytes max.