DataSet Guid Error inserting.

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
Posts: 3
Joined: Mon 17 May 2010 12:15

DataSet Guid Error inserting.

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.

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


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!

Devart Team
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

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.

Post Reply