Page 1 of 1
TWideStringField and MySQL
Posted: Mon 23 Nov 2009 07:01
by oz8hp
I use TUniQuery on a form to supply a TCRDBGrid with fields. When fields added by using fieldeditor they are declared like this
qryItemsflditem_GUID : TWideStringField;
This works with MS SQL and MS Access, but MySQL crashes if I will use that.
What to do?
Posted: Mon 23 Nov 2009 08:06
by Plash
Does MySQL table have different field name? What error do you get with MySQL?
Posted: Mon 23 Nov 2009 08:13
by oz8hp
The db is 100% identical in naming.
Expecting: WideString Recieved: String
Setting SpecificOptions.Values['UseUnicode'] := 'True' fixed that problem.
But I run some update code on the tables and that just takes forever to finish on MySQL. On MS Acess and MS SQL it takes just a blink of an eye.
Posted: Tue 24 Nov 2009 09:29
by Plash
Maybe your table is locked by another connection. What SQL statement hangs on MySQL?
Posted: Tue 24 Nov 2009 09:37
by oz8hp
Not a UniDAC problem - the server had made some sort of error and was running very slow in general.