DataSet Guid Error inserting.

insan2006 · Post by **insan2006** » Mon 17 May 2010 12:20

Hi! I'm use DataSet, DataBinding and TableAdapter.
I have 5.50 dotConnect for Mysql and i use BINARY(16) for GUID.

this.tableBindingSource.AddNew();
DataRowView TableRow= (DataRowView)(this.tableBindingSource.Current);
TableRow["ColumnGuid"] = Guid.NewGuid();
this.tableBindingsSource.EndEdit();

this.tableTableAdapter.Update(this.mDataSet.table);

And i have error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'B›h© м…', '`ёЁ€R•„D®н ќ±} ', '8', 1, NULL)' at line 1

Error appears periodically - probably until the bad characters in a query.

Why query executing such a terrible and BINAR transferred in a direct form but not in the form of x'00420430204' ?

I have a few months trying to solve the problem and now I have an urgent need to do it.

Please help!

StanislavK · Post by **StanislavK** » Tue 18 May 2010 14:13

Could you please send us a complete test project including the DataSet schema, connection properties and the definitions of the database objects? We couldn't reproduce the problem at the moment.