Hi,

designer version: 5.6 (5.6.1) RTM (21-ott-2019) database: 5.5.60-MariaDB

i have the following field:

duration FLOAT UNSIGNED DEFAULT NULL,

i think there is a bug in the designer, because it map the file as string (please see the attachment)

can you check please?

We don't test against mariadb but mysql db, but we see we have support for 'Float' but not 'unsigned float'.

As 'unsigned' is deprecated in mysql 8.x for float, is it a problem to remove the 'unsigned' attribute for this type in your db? If it is, we'll try to add a hotfix for this.

(the types come back from the db in the meta data as strings, hence our driver doesn't find the float and falls back to varchar)

Looks like a 5 minute fix, stay tuned

Please download 5.6.2 hotfix from the website. It supports unsigned float/double/decimal now. Hope this fixes your issue (you have to sync with the database again to make it assign the right types to the table fields)

It works, thanks !!!