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.
 
We are in need of some funding.
More details.

Thank you.

Members online

Back
Top