Hi Andy, thanks for the reply again.
Are you suggesting here a CHAR column with a column width of 1, and just insert either a 0 or 1 depending on whether the user type being submitted is an Advertiser or not?
I'm not sure if CHAR or TINYINT would be a better choice in this case?
Matt G
Quote:
Sure, that could work. I would use a SELECT field (no ENUM), and then have text values + the 0/1 values that get stored in trhe DB (just a bit nicer in terms of DB speed, especially if your user DB gets large)Are you suggesting here a CHAR column with a column width of 1, and just insert either a 0 or 1 depending on whether the user type being submitted is an Advertiser or not?
I'm not sure if CHAR or TINYINT would be a better choice in this case?
Matt G