DataSet Guid Error inserting.
Posted: 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!
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!