Max Fields in ZQuery-Result on MySQL5

Captnemo · Post by **Captnemo** » 28.06.2012, 16:32

can anyone tell me, if there is a limit to the number of fields in Zeos, that are a select on a MySQL5 database returned.
I have a Query on a Table with 330 fields. Over Zeos i got an ERangeError. In MySQL-Administrator the same Query works fine.

Thanks, Captnemo

Post by **EgonHugeist** » 28.06.2012, 17:04

Captnemo,

Normaly there is no imitation fields em selves. BUT we have got a imitation of the allocated memory. 6.6 does support 32kb per selcted row. Also do we allocate the max byte-size of a string field if it is empty or not.

You can use this branch http://zeos.firmos.at/viewtopic.php?t=3427 but this is Zeos alpha. In this branch i did increase the buffer to 64kb...

Michael

Captnemo · Post by **Captnemo** » 28.06.2012, 17:39

Thank you.