ZDbcMySQLStatement and Unicode parameters

[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.

[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

[bravecobra]

Tnx, at least that would make my framework work under Delphi 2010

[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

[mdaems]

SVN Rev 802

Mark