ajoo Posted October 21, 2020 Share Posted October 21, 2020 Hi all ! I am using mysql version 5.7.24 and I have run into the error under heading. The length of the email in question is 33 as given by select char_length('shiningstarstruste11111@gmail.com'); Most of the suggestions are to turn the strict mode off which I don't want to do. What would be the best way to resolve this ? Thanks ! Quote Link to comment https://forums.phpfreaks.com/topic/311622-data-too-long-for-column-email-error/ Share on other sites More sharing options...
requinix Posted October 21, 2020 Share Posted October 21, 2020 I don't think I understand. Are you suggesting there's at least one other equally-valid solution besides increasing the length of the column? Why is it even limited to 32 in the first place? 1 Quote Link to comment https://forums.phpfreaks.com/topic/311622-data-too-long-for-column-email-error/#findComment-1581990 Share on other sites More sharing options...
ajoo Posted October 22, 2020 Author Share Posted October 22, 2020 hmmm, I forgot to mention that the length of the column was 60 and i increased it to like 150 and then to 255 and it did not work, But ofcourse you are still right Requinix, on both counts. I had made changes in the wrong table. It's working now !! is 150 a good enough length for an email or should it be all the way up to the varchar limit? Thanks ! Quote Link to comment https://forums.phpfreaks.com/topic/311622-data-too-long-for-column-email-error/#findComment-1581991 Share on other sites More sharing options...
requinix Posted October 22, 2020 Share Posted October 22, 2020 Pretty sure nobody has an email address 65,535 characters long. Nor 150 either, for that matter. The technical limit is 320, but if you find someone complaining that their 151-character long email address isn't working in your system, you can deal with it then. 1 Quote Link to comment https://forums.phpfreaks.com/topic/311622-data-too-long-for-column-email-error/#findComment-1581992 Share on other sites More sharing options...
ajoo Posted October 22, 2020 Author Share Posted October 22, 2020 Thanks ! Quote Link to comment https://forums.phpfreaks.com/topic/311622-data-too-long-for-column-email-error/#findComment-1581995 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.