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 · 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.

Gerelateerde posts	Antwoorden	Weergaven
I cannot see custom field in lead form fields	2 dec. 25	5598
trying to match fields for products Opgelost fields	2 mrt. 26	2088
How to display a red * for required fields fields	3 mei 25	5942
How to display a red * for required fields fields	1 apr. 25	4278
one2one relational field Opgelost fields	3 sep. 24	18403

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!