Mysql 5.6 When using SchemaExport I am getting this issue "BLOB/TEXT column 'UserName' used in key specification without a key length" about nhibernate.aspnet.identity HOT 5 CLOSED

set map.Length(255);

from nhibernate.aspnet.identity.

That is already on your code

IdentityUser.cs

this.Property(x => x.UserName, map =>
{
map.Length(256);
map.NotNullable(true);
map.Unique(true);
});

This seems to me more like an issue on the nhibernate code.. maybe !

from nhibernate.aspnet.identity.

map.Length > 255 = BLOB/TEXT and not indexed...
I do fix map soon...
but at time, change "map.Length(256);" to "map.Length(255);" and run MapTests

P.S: Roles have the same problem!

from nhibernate.aspnet.identity.

I changed it to 256 to match EF but I shouldn't have done that. The length can be removed from the mapping and it will be 255 for any dialects.

from nhibernate.aspnet.identity.

I changed it to 255 and it worked. Thank you.

from nhibernate.aspnet.identity.