Page 1 of 1

ZDbcMySQLStatement and Unicode parameters

Posted: 16.01.2010, 17:41
by bravecobra
Hi,

in the current SVN repository is still an issue when using parameterized queries. When a parameter is being detected as stUnicodeString, then the PrepareSQLParam does not detect that (the case statement doesn't handle stUnicodeString).

I've attached the patch. Maybe we want to handle compiler versioning to this, since I've only tested on Delphi 2010.

On a side note, we might wanna check other database drivers as well, making sure all types are being handled.

Posted: 19.01.2010, 00:52
by mdaems
Brave,

his patch doesn't seem to break the test suite (but doesn't improve the results either). As adding an unsupported parameter can't hurt that much I committed this change.

SVN rev 770.

Mark

Posted: 20.01.2010, 20:13
by bravecobra
Tnx, at least that would make my framework work under Delphi 2010 :)

Posted: 09.04.2010, 05:53
by pcoenen
using Zeos SVN rev 800 and Delphi 2010

Hi,
Same problem with unicode string parameter Query and SQLite. Patch from BraveCobra also works here :-).

Is it possible to add it in ZDbcSqLiteStatement.pas (Line 361)

361 stString, stUnicodeString, stBytes:
362 Result := GetEscapeString(SoftVarManager.GetAsString(Value));

Pascal

Posted: 14.04.2010, 00:19
by mdaems
SVN Rev 802

Mark