Page 1 of 1
Wrong field type if extra info is included in field's type name by MariaDB
Posted: 16.09.2022, 08:58
by dcoun
I am using Mormot with ZEOS 8.0 and in a table the database definition as returned by Mariadb is
the above defination causes problem to ZEOS and from
Code: Select all
function TZRowAccessor.GetInt(ColumnIndex: Integer; out IsNull: Boolean): Integer;
in ZDBCcache it returns that this field is int64 and not a blob field as it should be.
Is it possible to ignore such extra info when defining and reporting field's type?
Re: Wrong field type if extra info is included in field's type name by MariaDB
Posted: 16.09.2022, 14:50
by marsupilami
Hello dcoun,
could you please supply a table definition that causes this problem? Maybe also a working exampl application that shows the problem?
Currently I am not sure what the exact problem is and how to reproduce it.
Best regards,
Jan
Re: Wrong field type if extra info is included in field's type name by MariaDB
Posted: 21.10.2022, 07:57
by dcoun
I apologize for the delay in my answer as zeos's was bypassed by mormot's code as you can see in this thread:
https://synopse.info/forum/viewtopic.php?id=6353
To have a compressed field in any mariadb's db table please check the following page:
https://mariadb.com/kb/en/create-table/#compressed
Re: Wrong field type if extra info is included in field's type name by MariaDB
Posted: 21.10.2022, 08:10
by dcoun
I apologize for the delay in my answer as zeos's was bypassed by mormot's code as you can see in this thread:
https://synopse.info/forum/viewtopic.php?id=6353
To have a compressed field in any mariadb's db table please check the following page:
https://mariadb.com/kb/en/create-table/#compressed
CREATE TABLE cmp (i TEXT COMPRESSED);