# MySql Stored Procedure Parameter BIT returns 200 with empty set

**URL:** <https://community.dreamfactory.com/t/mysql-stored-procedure-parameter-bit-returns-200-with-empty-set/3812>\
**Category:** REST API\
**Tags:** rest\
**Created:** [May 7, 2017, 12:50am UTC](https://community.dreamfactory.com/t/mysql-stored-procedure-parameter-bit-returns-200-with-empty-set/3812 "2017-05-07T00:50:07Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![drexelsharp](https://avatars.discourse-cdn.com/v4/letter/d/58956e/32.png) [@drexelsharp](https://community.dreamfactory.com/u/drexelsharp)\
**Post date:** [May 7, 2017, 12:50am UTC](https://community.dreamfactory.com/t/mysql-stored-procedure-parameter-bit-returns-200-with-empty-set/3812/1 "2017-05-07T00:50:07Z")

</div>

I have a mysql database with a stored procedure with one of the parameters as a **BIT** datatype. I am using Postman to test.

I’ve tried multiple types of calls using GET with query string params, POST with json body, etc. and it always returns an empty set [] with a status of 200. After troubleshooting the proc, I realized it was the BIT param.

I’ve tried changing the parameter value to 0,1,true,false,yes,no,t,f,y,n. Exact same result everytime.

I am aware that I could send TEXT or INT instead. But I was wondering if somebody else has come across this or if I’m doing something incorrectly or if it’s a bug.

Thanks!