Acceptable field type and size for email address? [duplicate]
According to RFC 5321, forward and reverse path can be up to 256 chars long, so the email address can be up to 254 characters long. You’re safe with using 255 chars.
fieldtype
Change type of varchar field to integer: “cannot be cast automatically to type integer”
There is no implicit (automatic) cast from text or varchar to integer (i.e. you cannot pass a varchar to a function expecting integer or assign a varchar field to an integer one), so you must specify an explicit cast using ALTER TABLE … ALTER COLUMN … TYPE … USING: ALTER TABLE the_table ALTER COLUMN col_name … Read more