Can I change the column to use text type instead of varchar for long strings on the backend? Replace all varchar(255) with text.
Or, even better, use appropriate data types instead of the "too large" ones. You don't really need 255 characters to store currency, do we?
The problem is that when the rebuild occurs it changes certain columns back to default maximum length.
When making new fields in espo and even if i set a limit it still uses the maximum size for the column.
Even if I change the column length on the back manually and rebuild it takes a column that I only need a length max of 10 and changes it to 255.
This is severly limiting how many fields I can add.
This has been brought up in the developer section but nobody seems to reply.
I have 180 fields in Entity "Accounts" so 65535/180 = an average of 364 characters per field.... that is insane especially for certain fields like US STATE(2), PHONE(12), CURRENCY(20 - MAX with decimals?), DATETIME(25 - MAX?) - Between the 4 fields with my num counts it should be less than (59) in length not (255)plus * 4 fields of (1000+) characters.
1000 - 59 = 941 spaces saved/not utilized.
https://forum.espocrm.com/forum/deve...size-too-large
Or, even better, use appropriate data types instead of the "too large" ones. You don't really need 255 characters to store currency, do we?
The problem is that when the rebuild occurs it changes certain columns back to default maximum length.
When making new fields in espo and even if i set a limit it still uses the maximum size for the column.
Even if I change the column length on the back manually and rebuild it takes a column that I only need a length max of 10 and changes it to 255.
This is severly limiting how many fields I can add.
This has been brought up in the developer section but nobody seems to reply.
I have 180 fields in Entity "Accounts" so 65535/180 = an average of 364 characters per field.... that is insane especially for certain fields like US STATE(2), PHONE(12), CURRENCY(20 - MAX with decimals?), DATETIME(25 - MAX?) - Between the 4 fields with my num counts it should be less than (59) in length not (255)plus * 4 fields of (1000+) characters.
1000 - 59 = 941 spaces saved/not utilized.
https://forum.espocrm.com/forum/deve...size-too-large
Comment