Page 1 of 1
binary(16) columns
Posted: Fri 05 May 2006 15:40
by ianbowles
I have a binary(16) column in my table, which MySql.Net returns as a column of type string. This means that character translation is done on the returned value and I end up with incorrect data. Shouldn't it be giving me a byte array by default, and how can I persuade it to do that?
Ian
Posted: Sat 06 May 2006 09:20
by Alexey
Use MySqlDataReader.GetBytes() method.
Posted: Wed 24 May 2006 03:32
by ianb
thanks, that would solve part of the problem, but what if the data is being fetched into a Datatable?
Ian
Posted: Wed 24 May 2006 06:37
by Alexey
We can't change MySqlDataTable behavior because lots of queries (like "show tables") would fail. We are going to implement MySqlString class in future to solve such a problems. Look forward to our future releases.