TWideStringField and MySQL

oz8hp · Post by **oz8hp** » Mon 23 Nov 2009 07:01

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?

Plash · Post by **Plash** » Mon 23 Nov 2009 08:06

Does MySQL table have different field name? What error do you get with MySQL?

oz8hp · Post by **oz8hp** » Mon 23 Nov 2009 08:13

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.

Plash · Post by **Plash** » Tue 24 Nov 2009 09:29

Maybe your table is locked by another connection. What SQL statement hangs on MySQL?

oz8hp · Post by **oz8hp** » Tue 24 Nov 2009 09:37

Not a UniDAC problem - the server had made some sort of error and was running very slow in general.