librebase doesn't work with year column type

Today I noticed that librebase (with direct connection to mysql) doesn’t work with “year” column type. If I change column type from year to varchar (always 4 characters) it works, but not with an “year” data.
There is a workaround?

This is depending on the connection you use.

I have tried it with direct connection, JDBC and ODBC. Direct connection won’t open the table, JDBC tries to create a data of it and ODBC works with SMALL INTEGER instead of YEAR. I would prefer SMALL INTEGER for the field. You will get a number and could set the form control to numbers, which will start with minimum year and maximum year.

1 Like

Thank you. I use “year” in mysql to get the current age of my “old” alumns. But I see iuf there is another way…