Bug in detecting datatypes
Posted: Mon Mar 12, 2018 7:55 pm
Hello,
Thank you for you support.
When using Mysql driver with custom query the returned datatype(s) is number in case of numeric,int and etc. fields, but in EditDataSource dialog it is recognized as int only. Also the Mysql Driver does not recognize integer datatype (I have checked this in the mysql adapter parseType function) , which is funny, since the returned type is always number.
In case of a lot of integer and decimal fields I always should set the correct datatype.
This is not comfortable and moreover not all developers(users) have access to the database to set the correct datatype.
The other adapters does not return the datatypes at all.
Thank you for you support.
When using Mysql driver with custom query the returned datatype(s) is number in case of numeric,int and etc. fields, but in EditDataSource dialog it is recognized as int only. Also the Mysql Driver does not recognize integer datatype (I have checked this in the mysql adapter parseType function) , which is funny, since the returned type is always number.
In case of a lot of integer and decimal fields I always should set the correct datatype.
This is not comfortable and moreover not all developers(users) have access to the database to set the correct datatype.
The other adapters does not return the datatypes at all.