Email Address Field Length

[Lemon]

I am setting up a database for a customer and they want to include a field for email address. I was going to set up the length of the field to 30 characters but I am not sure if this will be long enough. Anyone here have any sugestions.

[golfcart]

I wouldn't put a limit on the field length, but I would put a script in to verify that the adress is in the correct format. There are plenty of free javascripts floating around to do it, or you could use a server sided script to really be sure it's in the correct format.

[nick1]

While 30 chars are too few, considering international email could be longer, I would considering putting a limit of 50-100 chars depending your table/database/server capacity. And definately checking email format is a good idea.

Nick

[Lemon]

Thanks for the suggestions. Java won't work for this. It's on a mainframe database. I have to specify a length for it so I think I will go with 60. Sounds like a nice number to pick.........

[qball]

First, sixty may still be too small, it only takes one email of 61 chars for the truncating happiness to begin.

Java won't work for this. It's on a mainframe database.

Java most certainly works on any platform with a JVM (that's why they call it platform independent). I wrote a great message oriented middleware solution in Java on an AS400 mainframe. Anyway, then don't use Java, how about a trigger, or stored proc, or DB function. Also, verifying the format, well verifies the format, does little to validate address, but still a good idea.