I have a hard time believing that the 300M Chinese on the net have an email address spelled with ascii characters, but I just checked with our Exchange server here and on gmail, and both refused a single accented letter in the user name.
So you are right about restricting it. As for the "smaller field smaller db" excuse, utf8 is the same as ascii as long as you use strictly ascii characters. Also, the last I heard that excuse was for putting centuries in dates, thus saving 2 bytes for each date. We all know where that got us :) -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ruslan Zakirov Sent: July 28, 2008 14:29 To: Mathieu Longtin Cc: [email protected] Subject: Re: [rt-users] RT3.8 upgrade: forcing ascii email addresses? Nope, they can not. Only comment and phrase parts of addr_spec can, but address itself can not. However, may be soon we'll see international domains and situation could be changed, but at this point I think it's better to stick with ASCII. Smaller fields - smaller indexes - smaller DB. On Mon, Jul 28, 2008 at 8:23 PM, Mathieu Longtin <[EMAIL PROTECTED]> wrote: > Looking at the RT3.8 mysql upgrade script, I found out that most email > address fields are set to be ASCII characters only: > > > > ALTER TABLE Users MODIFY EmailAddress VARBINARY(120) NULL DEFAULT NULL; > > ALTER TABLE Users MODIFY EmailAddress VARCHAR(120) CHARACTER SET ascii NULL > DEFAULT NULL; > > > > This strike me as odd, since email address can contain international > characters, AFAIK. Correct me if I'm wrong. > > > > -- > > Mathieu Longtin > > Bureau: 1-514-270-7762x230 > > Portable: 1-514-803-8977 > > www.dbsoft.ca > > > > _______________________________________________ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com > Commercial support: [EMAIL PROTECTED] > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > -- Best regards, Ruslan. _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
