[keycloak-user] Keycloak user data encoding

[Igor Zuk]

Thank you for a quick response.

I’m using 1.9.2.Final and the problem is a bit different, it’s not limited to registration screen.

I’m saying, that ISO-8859-1 is the default encoding, because all the text columns in USER_ENTITY table had encoding latin1. The table was created completely by Keycloak as the database was empty in the beginning. I manually switched encoding of FIRST_NAME to UTF-8 and modified it so it contained special letters. I started the user editor in Keycloak admin console and this name was displayed correctly. I added a single character to it, saved, and then the name got messed up with question marks instead of all special characters.

From: Stian Thorgersen [mailto:sthorger at redhat.com]
Sent: Tuesday, July 12, 2016 3:43 PM
To: Stian Thorgersen <stian at redhat.com>
Cc: Igor Zuk <igor.zuk at qualitytaskforce.com>; keycloak-user at lists.jboss.org
Subject: Re: [keycloak-user] Keycloak user data encoding

By the way this was fixed in 1.6.0.Final, see https://issues.jboss.org/browse/KEYCLOAK-1830?jql=project%20%3D%20KEYCLOAK%20AND%20text%20~%20%22encoding%22

Are you using an old version?

On 12 July 2016 at 15:37, Stian Thorgersen <sthorger at redhat.com<mailto:sthorger at redhat.com>> wrote:
Why are you saying the default encoding is ISO-8859-1? All forms are encoded as UTF-8 and all strings passed to the database should be UTF-8 encoded as well.

The only thing that is ISO-8859-1 is the message properties, but those are converted to UTF-8 when added to HTML pages.

On 12 July 2016 at 14:58, Igor Zuk <igor.zuk at qualitytaskforce.com<mailto:igor.zuk at qualitytaskforce.com>> wrote:
Hi

I have an encoding problem. By default users' data fields (e.g. first name and last name) are encoded using ISO-8859-1. People from many countries can't properly create accounts as their personal data is silently messed up. How can I fix it?

•         The MySQL DB receives already damaged names. By default all columns are ISO-8859-1-encoded, but manually converting them to UTF-8 doesn't help.

•         Manual account modification from admin console has same effect.

•         Change of default server (Wildfly) encoding to UTF-8 doesn't do anything.

Best regards
Igor Żuk

_______________________________________________
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/20160712/895d4492/attachment.html