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??
Strings returned as Byte[]
Re: Strings returned as Byte[]
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?
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Strings returned as Byte[]
It was done to add a possibility to convert byte array to a string with a needed encoding, not only with the default one.Chunki wrote:Could you tell me why does it happen, and how to fix it?
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();