Strings returned as Byte[]

[joy87]

i'm using mysql connector version 6.6 and mysql server 5.5.
earlier when i was using the older versions of mysql and devart connector string was returned from db as string but when i updated both the string is now returned as Byte[].
Can u tell me what the issue is??

[Shalex]

We have answered you by e-mail.

[Chunki]

same issue here, though I use MySQL 5.1 and dotConnect for MySQL 6.80.350. Could you tell me why does it happen, and how to fix it?

[Pinturiccio]

Could you tell me why does it happen, and how to fix it?

It was done to add a possibility to convert byte array to a string with a needed encoding, not only with the default one.
We have implemented a new public static class OldCompatibility starting from the 5.80.190 build of dotConnect for MySQL. Please use it in the following way to obtain the previous behaviour ( binary (MySQL) -> string (.NET)):

Code: Select all

OldCompatibility.BinaryAsString = true;
MySqlConnection conn = new MySqlConnection("User id=root;pwd=root;port=3306;host=localhost;database=test");
conn.Open();