Postgres, ZEOS and Visual PlanIt - unable to create a table

[wp]

I am not very experienced with ZEOS and MySQL/MariaDB. What is the value of the FConnection.Protocol in TVpZeosDatastore.AdjustSQLFieldTypeNames? Don't you have to set that to "mariadb" in order to tell ZEOS that it will find a MariaDB database? Or is there some autodetection so that you can leave Protocol empty?

I just tested my ZEOS datastore test project with protocol='mariadb' for a mysql database, and it is working correctly. Therefore, what happens when you set protocol to 'mysql' although you have a mariadb database?

[calebs]

i've been using zeos (stable 8 from OPM) and always use mysql as protocol with mysql or mariadb engines, in every version i've tried. (i believe until 10.x, cant recall used mariadb 11 or 12). And zeos always work with mysql as protocol on mysql or mariadb.
I dunno if zeos from vp is a newer version that makes difference but until now zeos 8 from opm always worked.
in the example i gave of the time that worked i was using maridb as db engine and mysql as protocol in zeos and worked fine.
netherveless, it didnt recognize mysql or mariadb because i've modified the two sections (mariadb and mysql) and never choses any of them. That's why worked when i change the "default values" i think from lines 127 and after

[wp]

I dunno if zeos from vp is a newer version that makes difference but until now zeos 8 from opm always worked.

I tested the ZEOS datastore and demo with ZEOS 8

in the example i gave of the time that worked i was using maridb as db engine and mysql as protocol in zeos and worked fine.
netherveless, it didnt recognize mysql or mariadb because i've modified the two sections (mariadb and mysql) and never choses any of them. That's why worked when i change the "default values" i think from lines 127 and after

Just to make sure that I am understanding correctly: You modified the first lines in TVpZeosDatastore.AdjustSQLFieldTypeNames to those that you showed earlier because the "if" code in the mysql and mariadb sections was not entered? Strange... It would be interesting what the debugger tells you for the value of the "protocol" variable when you put a break-point in this routine.

Nevertheless, I learned from your answer that it is not important to have Protocol='mysql' or 'mariadb' for a mysql or mariadb database. Therefore I merged both "if" branches into the same "if (protocol = 'mysql') or (protocol = 'mariadb')" in the latest version in the CCR SVN repository.

[calebs]

thanks wp
first of all, careful with this

Nevertheless, I learned from your answer that it is not important to have Protocol='mysql' or 'mariadb' for a mysql or mariadb database. Therefore I merged both "if" branches into the same "if (protocol = 'mysql') or (protocol = 'mariadb')" in the latest version in the CCR SVN repository.

because mariadb was a clone of mysql but as i have seen lately they are trying to make difference in some ways with mysql, so, as i told you before, i havent tried latest mariadb servers and i don't know if 11 or 12 will work with mysql protocol or need mariadb protocol (someone with more knowledge of this engines can tell better). I think for compatibility should work but cant be sure of that.
I will try to debug that part to see if it enters or not in those if sections and share here the experiencie.

[wp]

Well, I leave it like this for the moment. If we (=you) find an incompatibility with a later version of mariadb the two cases can be separated again easily.