# How to query a confirmation-type custom user field?

**URL:** <https://meta.discourse.org/t/how-to-query-a-confirmation-type-custom-user-field/68397>\
**Category:** Support\
**Created:** [August 19, 2017, 11:12pm UTC](https://meta.discourse.org/t/how-to-query-a-confirmation-type-custom-user-field/68397 "2017-08-19T23:12:11Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![zogstrip](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/zogstrip/32/512781_2.png) [@zogstrip](https://meta.discourse.org/u/zogstrip)\
**Post date:** [August 20, 2017, 10:30am UTC](https://meta.discourse.org/t/how-to-query-a-confirmation-type-custom-user-field/68397/2 "2017-08-20T10:30:51Z")

</div>

Boolean custom fields are stored as `"t"` and `"f"` in the database.

> [@tophee](#):
>
> BTW, I found it confusing that the datatype of a confirmation type user field is not boolean but text. I figure it’s to keep the user field table simple with just one data type?

That’s because all custom fields are store as string in the database and are casted to int/boolean/json/array on load.

---

_[View the full topic](https://meta.discourse.org/t/how-to-query-a-confirmation-type-custom-user-field/68397)._