Page 1 of 1

Max Fields in ZQuery-Result on MySQL5

Posted: 28.06.2012, 16:32
by Captnemo
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

Posted: 28.06.2012, 17:04
by EgonHugeist
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

Posted: 28.06.2012, 17:39
by Captnemo
Thank you.