blueman378 Posted November 24, 2008 Share Posted November 24, 2008 hi guys, well the title basically says it all, id assume you would set it as varchar(515) as that accomodates for (255char)@(255char).(3char) which is the largest email you can have correct? Quote Link to comment https://forums.phpfreaks.com/topic/134000-best-way-to-store-email-in-database/ Share on other sites More sharing options...
Mchl Posted November 24, 2008 Share Posted November 24, 2008 I seriously doubt that anyone has an email address that long. Come on... 515 characters is half a page! I just do VARCHAR(255) and always wonder if it's not too long. Quote Link to comment https://forums.phpfreaks.com/topic/134000-best-way-to-store-email-in-database/#findComment-697499 Share on other sites More sharing options...
blueman378 Posted November 24, 2008 Author Share Posted November 24, 2008 id be tempted to register a domain that long jsut so i could say i have that email address, but seriously, 255 would be ok, instead of catering for the possiblility? Quote Link to comment https://forums.phpfreaks.com/topic/134000-best-way-to-store-email-in-database/#findComment-697501 Share on other sites More sharing options...
Mchl Posted November 24, 2008 Share Posted November 24, 2008 I'd say so. If anyone with longer email shows up, redirect them to gmail. Quote Link to comment https://forums.phpfreaks.com/topic/134000-best-way-to-store-email-in-database/#findComment-697503 Share on other sites More sharing options...
blueman378 Posted November 24, 2008 Author Share Posted November 24, 2008 yeah true imagine typing in Atwohundredandfiftyfiveleteremailaddressthatcouldcontainanythingfrom1234567890rightthroughtoabcdefghijklmnopqrstuvwxyzitwouldtakeforfriggeneverlolsoreallyevenifyoudidownthatemailyouwouldneveruseritsoitwouldbepointlesstoacommodateforitsoiguessyouarerighteh@Atwohundredandfiftyfiveleteremailaddressthatcouldcontainanythingfrom1234567890rightthroughtoabcdefghijklmnopqrstuvwxyzitwouldtakeforfriggeneverlolsoreallyevenifyoudidownthatemailyouwouldneveruseritsoitwouldbepointlesstoacommodateforitsoiguessyouarerighteh.com Quote Link to comment https://forums.phpfreaks.com/topic/134000-best-way-to-store-email-in-database/#findComment-697532 Share on other sites More sharing options...
Mchl Posted November 24, 2008 Share Posted November 24, 2008 You would hate those forms with: 'Type your email again for confirmation', eh? Quote Link to comment https://forums.phpfreaks.com/topic/134000-best-way-to-store-email-in-database/#findComment-697534 Share on other sites More sharing options...
seany123 Posted November 24, 2008 Share Posted November 24, 2008 no, copy + paste...... then u realise you mistyped LOL Quote Link to comment https://forums.phpfreaks.com/topic/134000-best-way-to-store-email-in-database/#findComment-697535 Share on other sites More sharing options...
beansandsausages Posted November 24, 2008 Share Posted November 24, 2008 yeah true imagine typing in Atwohundredandfiftyfiveleteremailaddressthatcouldcontainanythingfrom1234567890rightthroughtoabcdefghijklmnopqrstuvwxyzitwouldtakeforfriggeneverlolsoreallyevenifyoudidownthatemailyouwouldneveruseritsoitwouldbepointlesstoacommodateforitsoiguessyouarerighteh@Atwohundredandfiftyfiveleteremailaddressthatcouldcontainanythingfrom1234567890rightthroughtoabcdefghijklmnopqrstuvwxyzitwouldtakeforfriggeneverlolsoreallyevenifyoudidownthatemailyouwouldneveruseritsoitwouldbepointlesstoacommodateforitsoiguessyouarerighteh.com Looks like you broke th quote box Quote Link to comment https://forums.phpfreaks.com/topic/134000-best-way-to-store-email-in-database/#findComment-697811 Share on other sites More sharing options...
Maq Posted November 24, 2008 Share Posted November 24, 2008 If someone has an email that long they're either a spammer or don't deserve to be stored in a database. Problem solved... Quote Link to comment https://forums.phpfreaks.com/topic/134000-best-way-to-store-email-in-database/#findComment-697814 Share on other sites More sharing options...
revraz Posted November 24, 2008 Share Posted November 24, 2008 I've been to sites where they disable copy and paste just for this reason. no, copy + paste...... then u realise you mistyped LOL Quote Link to comment https://forums.phpfreaks.com/topic/134000-best-way-to-store-email-in-database/#findComment-697825 Share on other sites More sharing options...
seany123 Posted November 24, 2008 Share Posted November 24, 2008 I've been to sites where they disable copy and paste just for this reason. no, copy + paste...... then u realise you mistyped LOL generally there should be no reason to disable use of copy and paste functions... Quote Link to comment https://forums.phpfreaks.com/topic/134000-best-way-to-store-email-in-database/#findComment-698062 Share on other sites More sharing options...
revraz Posted November 24, 2008 Share Posted November 24, 2008 Defeats the purpose of repeating it. If you typed something wrong in the first box, then you would catch it in the second box by retyping it. If you just copy/paste, all you do is copy the first error with it. Quote Link to comment https://forums.phpfreaks.com/topic/134000-best-way-to-store-email-in-database/#findComment-698073 Share on other sites More sharing options...
blueman378 Posted November 24, 2008 Author Share Posted November 24, 2008 yeah true imagine typing in Atwohundredandfiftyfiveleteremailaddressthatcouldcontainanythingfrom1234567890rightthroughtoabcdefghijklmnopqrstuvwxyzitwouldtakeforfriggeneverlolsoreallyevenifyoudidownthatemailyouwouldneveruseritsoitwouldbepointlesstoacommodateforitsoiguessyouarerighteh@Atwohundredandfiftyfiveleteremailaddressthatcouldcontainanythingfrom1234567890rightthroughtoabcdefghijklmnopqrstuvwxyzitwouldtakeforfriggeneverlolsoreallyevenifyoudidownthatemailyouwouldneveruseritsoitwouldbepointlesstoacommodateforitsoiguessyouarerighteh.com Looks like you broke th quote box opps but yeah, i agree with you guys, if anyone enters an email too long ill just tell em to bug off Cheers Quote Link to comment https://forums.phpfreaks.com/topic/134000-best-way-to-store-email-in-database/#findComment-698214 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.