[keycloak-dev] Oracle stores an empty string as null

Stian Thorgersen sthorger at redhat.com
Fri Nov 17 08:30:07 EST 2017


Probably yes

On 17 November 2017 at 12:54, Man Yue Mo <mmo at semmle.com> wrote:

> Hi,
>
> Would there be issue with these also? https://lgtm.com/query/
> 1505886556363/ Thanks.
>
> Man Yue Mo
>
> On 17 November 2017 at 08:50, Stian Thorgersen <sthorger at redhat.com>
> wrote:
>
>> If you try to store an empty string in Oracle it is actually stored as a
>> null [1].
>>
>> We actually often store empty strings due to the way AngularJS works. An
>> empty input on a form ends up being sent as an empty string rather than a
>> null.
>>
>> This can lead to all sorts of fun issues. For example
>> https://issues.jboss.org/browse/KEYCLOAK-5308.
>>
>> [1]
>> https://stackoverflow.com/questions/13278773/null-vs-empty-
>> string-in-oracle
>> _______________________________________________
>> keycloak-dev mailing list
>> keycloak-dev at lists.jboss.org
>> https://lists.jboss.org/mailman/listinfo/keycloak-dev
>>
>
>


More information about the keycloak-dev mailing list