[keycloak-dev] Fwd: Increasing User Attribute column size

[Sylvere RICHARD]

Hi,

I'm facing an issue described in this jira:
https://issues.jboss.org/browse/KEYCLOAK-9515

This issue could be easily fixed by increasing the size of the User
Attribute column (currently 255 chars).

After investigating, it seems this increase has :
- no effect on Postgres performance (ref:
https://wiki.postgresql.org/wiki/Don%27t_Do_This#Text_storage)
- minor effect on MySQL (ref:
https://dba.stackexchange.com/questions/76469/mysql-varchar-length-and-performance
)
<https://dba.stackexchange.com/questions/76469/mysql-varchar-length-and-performance>
- some performance degradation on SQLServer (ref:
https://sqlperformance.com/2017/06/sql-plan/performance-myths-oversizing-strings
)

Yet, the user attribute field is too small for my use-case (storing the raw
user information provided by an external identity provider), and even too
small to theorically store an email (according to the RFC 3696, an email
could reach 320 chars long).

Would it be possible to increase this field to a size of 2000 chars for
example?

S.