Char and Varchar

mariluzrm

Member
Hello.

I have a table field name "ordinvpr". It is CHAR(25) and I want to change the label. When I edit the element to change the label, and I click "Save" this message appears:

Update field structure for `ORDINVPR` from CHAR(25) to VARCHAR(25)

Aren't CHAR fields allowed? Should I change them all?

Thanks



 
Char is for fixed length strings, so normally you would want to use varchar with Fabrik field elements which is also a default.

So when saving a Char element Fabrik automatically suggest to change it to Varchar.

You probably don't need to change all the existing char elements at once, if there are no issues.
 
Back
Top