12-18-2003, 02:57 PM
Probably a really stupid question. I sure don't think they'd ever pose a problem, but figured I'd get a 2nd or 3rd opinion. We have a standard of UCasing all data before insertion to the oracle tables. The report developer who's reports will be using the email addresses just asked me if they're case sensive.
12-18-2003, 03:58 PM
/me doesnt just a think® they are either...'cept you could just a try® n' email one to yourself n' just a double® check...
BigDaddy@yourdomain.com n' email@example.com
n' just a remember®.../me isnt just a programmed® to think n' nooo question is just a stupid® ifin' ya learn from it...:O)))
12-18-2003, 04:06 PM
Emails for most part are not case sensitive. I have seen some emails bounce back with out a capital from a server once in awhile, But I send emails out of my system to my account with multiple ways
when tetsing my HelpDesk System. I could ask the email guy here an my work if it depends on setting, but I really doubt there is a problem.
Wow, I do not think I actaully said anything above!
are emailadresses like
valid? + what happens if you ucase that ?
Why ucasing all data? doesn't oracle have caseinsesitive variabletypes?
12-18-2003, 11:22 PM
It depends, the domain part of an email address (everything after the '@' character) is not case sensitive since domain names are not case sensitive.
The username however, may be case sensitive because the host manages the user accounts. It depends on the particular host. Some systems may consider "JaneDoe" and "janedoe" to be different usernames, but it's not common.
12-19-2003, 12:35 AM
Originally posted by raf
are emailadresses like
if you try to subscribe to http://www.caramail.lycos.fr/ which is the biggest community/email-addy site for french speaking people you can't use the "ç". You would find this char probably in french. If you try to use this username: françois.couillé@caramail.com here are some of the choices they give you for that username:
same for hotmail...
I see. I guess it makes sense.
Thanks for the info jeskel.
12-19-2003, 10:40 AM
it could be because of "english standard letters" compliance. If caramail.com lets their users enter the "ç" then it would have to be recognized by every site that provides email address. Might that guess be right? And it has obviously no Ucase. However you can can Ucase the "é": "É". But the letter doesn't exist properly, you have to do an "Alt Gr" + "´" and then "E". So I guess it is an issue at some point...
12-30-2003, 05:00 AM
I think we ALL appreciate that kind of information - I especially appreciate any kind of first-hand programming experience and input when it comes to people from different countries dealing with email addresses!
Among problems like that is the fact that although regular expressions are extremely powerful as a programming tool, they don't take into account international characters (assuming you're from the USA), and I haven't even had a chance to scrape the surface in that regard... anyone have any input there?
Not to mention that to date, I still haven't been able to decipher a real logic base from the appropriate RFC or any actual rules regarding what is allowed and what is not allowed regarding email addresses.
I'd think if ANYTHING was going to be a standard on the 'net, then you'd start with email addresses at this point.
I've seen some attempts to do so, but they fail when it comes to apparently legal email addresses, which are able to send and receive email!...