[rt-users] RT3.8 upgrade: forcing ascii email addresses?

[Ruslan Zakirov]

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 <mlongtin at dbsoft.ca> 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: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>



-- 
Best regards, Ruslan.