Limiting field size in V14 onwards

Question

Since V14 the fields size parameter (size=x) is no longer valid on field definitions.
What is the correct way to limit the size of a string field in the database (not the view) so that the length is automatically cropped to 18 characters?
Please note that I need to do this on a related field:
fields.Char(string='CSV Memo', related='ref', store=False)
Originally in V13 I used:
fields.Char(string='CSV Memo', related='ref', store=False, size=18)

Chris Mann · Accepted Answer

Interesting update. I actually tried adding back size attribute to a field in V15 and it works without issue or any warning in the log! I was surprised as I took the advice from an OCA article https://github.com/OCA/maintainer-tools/wiki/Migration-to-version-14.0. [1]
However I can see that even in V16 there are still many uses of the size attribute used on char fields, for example:
https://github.com/odoo/odoo/blob/16.0/addons/l10n_de/models/datev.py [2]
Anyone know if Odoo backtracked on this

Malay Khamar (Serpent Consulting Services Pvt. Ltd.) · Answer

HI Chris Mann,
Second option will be try to add constraints and check length of the char field in its method. You can raise exception for the size exceed.
If you want to automatically crop it to 18 char , then you have to follow the string slicing. But on you case its related field , so might be automatically cropped will not work.
Hope it will help you.

Related Posts	Replies	Views
one2one relational field Solved fields	3 Sep 24	10000
Is there a maximum data size limit for Odoo SaaS clients? size	1 Jul 24	4237
I cannot see custom field in lead form fields	2 Feb 24	606
calculated fields fields	1 Jul 23	1011
How can i bring a field from the Customer into the invoices? Solved fields	2 Jun 23	1402

This question has been flagged

Enjoying the discussion? Don't just read, join in!