Zeoslib Portal

After upgrading from version 6.6.6 to 7.2, I ran into difficulty. Now in requests it became necessary to explicitly specify the type of the output field. These moments I was able to solve in my project. But a new issues has come out, SHOW FIELDS FROM MyTable, the output fields are of type BlOB. It's...

A lot of thanks for the advice.

Thank you very much for your reply and your time. I'll have to recheck all query for correctness display by using zeos v7.

I'm not looking for a solution, I wonder, which Zeos version works correctly v.6.6.6 or v.7? The thing is that in User Manual by mysql it is stated: Returns the string that results from concatenating the arguments. May have one or more arguments. If all arguments are nonbinary strings, the result is...

nil

I am use MySQL 4.1.16 Query - select concat(f1," ",f2) as A, f1,f2 from t1 Table have 1 row f1 - 0000-00-00 - type DATE f2 - 0000-00-00 - type VARCHAR http://warcan.net/test/Test.jpg In manual by concat "...If the arguments include any binary strings, the result is a binary string.......

Hi, I use Delphi7+Zeos 7. I have some query including construction - concat(f1," ",f2) as F , where f1 or f2 field by date or time. After query opening in ZQuery, field F have type - bytes. Version late 7.0 return type - string. When f1 and f2 not date or time return type - string. It is c...