Page 1 of 1
Strings returned as Byte[]
Posted: Wed 11 Apr 2012 20:37
by 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??
Posted: Thu 12 Apr 2012 09:39
by Shalex
We have answered you by e-mail.
Re: Strings returned as Byte[]
Posted: Wed 09 May 2012 07:02
by 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?
Re: Strings returned as Byte[]
Posted: Fri 11 May 2012 08:39
by Pinturiccio
Chunki wrote: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();