VARCHAR(MAX) = 6 characters

[smason (Scott Mason)]

Does it make sense that I have a VARCHAR(MAX) field but the UI will only let me enter 6 characters? Is this some limitation? Do I have to change the varchar size in the database to fix this?

When I use the front end I’m only allowed to type 6 chars:

[ckrusen (Calvin Krusen)]

@smason

Do I have to change the varchar size in the database to fix this?

Yes. Where you created SpecialInstructions_c

Example:

You’ll probably need to “regenerate the data model” (or whatever it’s called in the Epicor Admin Console)

[smason (Scott Mason)]

Yes I did that.

It’s setup correctly there and we regenerated. The field is in the DB.

[ckrusen (Calvin Krusen)]

Is MAX a valid value in that field? Does it work if you set it to some big number (like 65,000)?

[hkeric.wci (Haso Keric)]

I dont think MAX is valid in Epicor, the front-end doesnt know how to translate that. Must use a number.

[smason (Scott Mason)]

Do you know if we can just change MAX to a number and regenerate or do we have to delete the field, regen, then remake the field and regen?

[hkeric.wci (Haso Keric)]

Epicor by default will do x(8) so im assuming they defaulted to x(8) you should be okay changing it and regen and recycle iis again.

[ckrusen (Calvin Krusen)]

@smason- I looked at the Extended Properties of some builtin tables, and noticed that a Default Format isn’t always specified.

Maybe try leaving it blank

[Carson (Carson Ripple)]

x(1000) is converted to nvarchar(max).