e-mail address too long

Creating tables and queries

e-mail address too long

Postby bushwhacker » Sat Dec 12, 2015 11:54 pm

I am entering an e-address for a new member of our club. when I try to save it, I get a message that the e-address it too long.There are already several longer addresses entered in the data-base. How can I overcome this?
bushwhacker
 
Posts: 18
Joined: Thu Nov 29, 2007 4:38 am

Re: e-mail address too long

Postby charlie.it » Mon Dec 14, 2015 7:18 pm

What field type have you selected in your table? The type text should be fine. Try to increase the length.
charlie
macOS 10.12 Sierra: Open Office 4.1.7 - LibreOffice 6.2.8

http://www.charlieopenoffice.altervista.org
User avatar
charlie.it
Volunteer
 
Posts: 331
Joined: Wed Aug 21, 2013 2:12 pm
Location: Italy

Re: e-mail address too long

Postby bushwhacker » Mon Dec 14, 2015 7:55 pm

I am pretty sure the column is set for text. I created a new table for 2016 from 2015 table, which has longer e-mails. The one I am trying to enter is missing the .com. I can add the . but any more characters brings the "error updating the current record, value too long in statement [UPDATE ' ' SET 'email' WHERE ID = ?] Expanding the length of the column doesn't help
bushwhacker
 
Posts: 18
Joined: Thu Nov 29, 2007 4:38 am

Re: e-mail address too long

Postby RoryOF » Mon Dec 14, 2015 8:01 pm

Is there any odd (i.e., non standard ASCII) character in the email address?
Apache OpenOffice 4.1.7 on Xubuntu 18.04.4 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 30418
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: e-mail address too long

Postby bushwhacker » Mon Dec 14, 2015 10:00 pm

Only lower case letters and @ and .
bushwhacker
 
Posts: 18
Joined: Thu Nov 29, 2007 4:38 am

Re: e-mail address too long

Postby charlie.it » Tue Dec 15, 2015 11:33 am

Can you attach a copy of your files? (no sensitive data).
charlie
macOS 10.12 Sierra: Open Office 4.1.7 - LibreOffice 6.2.8

http://www.charlieopenoffice.altervista.org
User avatar
charlie.it
Volunteer
 
Posts: 331
Joined: Wed Aug 21, 2013 2:12 pm
Location: Italy


Return to Tables & Queries

Who is online

Users browsing this forum: No registered users and 1 guest