Creating indexes in mysql?

[eluser]kyleect[/eluser]
[quote author="bretticus" date="1238546492"]If you are using fields as utf8 for example I believe it uses up 3 bytes per character. Thus, you are limited to 333 characters for a key. This may be because you have an older version of MySQL. I see no reason why username and password would need 255 characters each. You need a username length policy (32 chars is common) and if anyone has an email with more than say 50 or 100 characters, they are out of their minds!!! You could set length to 100 an be totally fine.[/quote]

Thanks, that makes sense.

@Aea: 8-16 characters, for an email address?