[keycloak-user] ERROR: value too long for type character varying(255)

[Remi Cartier]

Stian,

thank you for your response.

255 might be sufficient for most person, I don’t see the need for a JIRA for that.
However if there was an indication on how to change that limit, the file to modify / add, etc … in some documentation that would be great.

Regards.

________________________________

REMI CARTIER
B.O.S.S. (Business & Operation Support Systems) P.O (Product Owner)

IMETRIK GLOBAL INC.
T : +1 514 448-6407 x2009
T : +1 866 276-5382 (toll free)
F : +1 514 904-0611

740 Notre Dame St. West, Suite 1575
Montreal, Quebec, Canada H3C 3X6
imetrik.com<http://www.imetrik.com/>

On Oct 12, 2015, at 2:27 AM, Stian Thorgersen <sthorger at redhat.com<mailto:sthorger at redhat.com>> wrote:

255 is the "default" length, no other good explanation why it's that short. Create a JIRA and we can increase it. Text is not supported by all database we support so we can't use that, but we can at least increase the size.

We use Liquibase to create db schema, not Hibernate.

On 9 October 2015 at 18:35, Remi Cartier <remi.cartier at imetrik.com<mailto:remi.cartier at imetrik.com>> wrote:
Hi guys,

it seems the size of an attribute is limited to 255 characters.
That is quite small considering one might want to store JSON into attributes.

Would simply change the hibernate config file to use TEXT vs VARYING(255) be enough ?

any reason for that artificial limitation ?

Cheers !

________________________________

REMI CARTIER
B.O.S.S. (Business & Operation Support Systems) P.O (Product Owner)

IMETRIK GLOBAL INC.
T : +1 514 448-6407 x2009<tel:514%20448-6407%20x2009>
T : +1 866 276-5382<tel:866%20276-5382> (toll free)
F : +1 514 904-0611<tel:514%20904-0611>

740 Notre Dame St. West, Suite 1575
Montreal, Quebec, Canada H3C 3X6
imetrik.com<http://www.imetrik.com/>


_______________________________________________
keycloak-user mailing list
keycloak-user at lists.jboss.org<mailto:keycloak-user at lists.jboss.org>
https://lists.jboss.org/mailman/listinfo/keycloak-user


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/keycloak-user/attachments/20151013/824e75fb/attachment-0001.html