# DBI MySQL Win returns nil for TINYINT(1) values

**URL:** <https://www.ruby-forum.com/t/dbi-mysql-win-returns-nil-for-tinyint-1-values/145223>\
**Category:** Ruby\
**Created:** [August 6, 2008, 10:34pm UTC](https://www.ruby-forum.com/t/dbi-mysql-win-returns-nil-for-tinyint-1-values/145223 "2008-08-06T22:34:14Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![kyle](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/k/848f3c/32.png) [@kyle](https://www.ruby-forum.com/u/kyle)\
**Post date:** [August 6, 2008, 10:34pm UTC](https://www.ruby-forum.com/t/dbi-mysql-win-returns-nil-for-tinyint-1-values/145223/1 "2008-08-06T22:34:14Z")

</div>

Hello! I’m using Ruby on Windows to access a local MS SQL database  
and update a remote MySQL database. I’m able to connect to the remote  
database using DBI, and it pulls most of the data as expected;  
however, any TINYINT(1) field is returned as nil, not true/false or  
1/0. This doesn’t happen when I run the same script in linux. Any  
ideas? I’d be happy to give any info that could be helpful.

Thanks!

-Kyle