Zeoslib Portal

Hi Adaptec, I think your problem is coming from unit 'ZDbcMySqlUtils', after line 222: FIELD_TYPE_TINY_BLOB, FIELD_TYPE_MEDIUM_BLOB, FIELD_TYPE_LONG_BLOB, FIELD_TYPE_BLOB: if (FieldFlags and BINARY_FLAG) = 0 then Result := stAsciiStream else Result := stBinaryStream; The type of the field. The type ...

Hi,

Here is my small PATCH to solve reopen problem with ADO (MSSQL/OLEDB).

Please take a look into.

Thanks.

I don't mimd if you post my erros here... :-) This is the place of our "work"/discussion.

Your fix is correct !!! It was my fault... -->> '(...)' is needed!!! I should commit this changes.

Attila

ps.: Thanks for your congratulation.

Hi,

I will to take a look into the test site. But I could not give you any deadline. If I could solve any problem I will send you the PATCH and I will post my results here.

Regards,

Attila

Hi, This failure is only ADO related and only in ZeOS version 7. This sample code running without problem(==without paramcheck ) under Delphi 7 + ZeOS 6.6 + ADO. I try to move my D7 + ZeOS 6.6 based product into D2010. I have problem only with ZeOS 7. This is the reason why I try to solve lots of pr...

Because the latest stable (6.6.x) does not work under Delphi 2009/2010/XE.

Hi Mark,

I use 5.1.50 version of MySQL.

Regards,
Attila

Hi, YES! :-) The database modul what I use for my tests it is part of my D7/ZeOS 6.6.x based solution: http://pergersoft.hu/termekek/smartstorage SELECT FAZONOSITO, FRIPORT, FIDO, FUSER FROM TRIPORTOK WHERE FNEV = :NEV AND FTIPUS = :TIPUS It is tested and working in production with potgresql, mysql,...

Hi All, I did some test with ADO protocol under D2010 (with the latest 7.0 testing branch). You can see my simple example bellow. If cbWithANSIParams.Checked is false, we got one line from the DB. If cbWithANSIParams.Checked is true, the first execution provides empty resultset. But what about with ...

Hi mdaems, I have created a PATCH for MySQL/PostgreSQL (and maybe for other types, too!) to handle the character sets in correct way. I think in MySQL parts contains a BUG, because there was not identified the type of character based fields correctly, because the character set property was by-passed...

Thanx everybody to work on this problem! I think "ibrahim"'s modification is close to solution of "KDeveloper2". On additional point: What is the meaning of these connection parameters? And what is the different between 'client_encoding' and 'codepage'? connBlobTest.Properties.Va...

Hi...

Ooohhhh I forgot it... :-)

The BLOB problem is NOT solved, only the PostgreSQL parts is working, why???

Hi All, I have created a small test program to show what is my problem with characher sets. Here is my code snipet (attched ZIP contains the full source): // Why the encoding is working in different way at different protocols (DB type)? // It is worg! if ContainsText(connBlobTest.Protocol, 'postgres...

Please, read this thread:

http://zeos.firmos.at/viewtopic.php?t=2678&highlight=