# Mssqlclient returns nil for money, decimal, numeric fields

**URL:** <https://www.ruby-forum.com/t/mssqlclient-returns-nil-for-money-decimal-numeric-fields/87860>\
**Category:** Ruby\
**Created:** [March 6, 2007, 1:49pm UTC](https://www.ruby-forum.com/t/mssqlclient-returns-nil-for-money-decimal-numeric-fields/87860 "2007-03-06T13:49:13Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ther](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/977dab/32.png) [@ther](https://www.ruby-forum.com/u/ther)\
**Post date:** [March 6, 2007, 1:49pm UTC](https://www.ruby-forum.com/t/mssqlclient-returns-nil-for-money-decimal-numeric-fields/87860/1 "2007-03-06T13:49:13Z")

</div>

Only real and float field types return values as they should.

Since I haven’t found nothing on the subject on net I wonder if it’s  
only me.

by

TheR

---

<div class="post-metadata">

**Author:** ![ther](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/977dab/32.png) [@ther](https://www.ruby-forum.com/u/ther)\
**Post date:** [March 6, 2007, 5:30pm UTC](https://www.ruby-forum.com/t/mssqlclient-returns-nil-for-money-decimal-numeric-fields/87860/2 "2007-03-06T17:30:45Z")

</div>

On Mar 6, 6:49 am, Damjan R. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> Posted viahttp://www.ruby-forum.com/.  
> The mssqlclient works well enough for a demo at this point, but is not  
> fit for production. You should check out the source (http://  
> [rubyforge.org/scm/?group\_id=2344](http://rubyforge.org/scm/?group_id=2344)) and fix the bugs before you stick it  
> into a live site. I do know that it passed more tests than the built-  
> in MSSql adapter, so it’s a little odd that it wont return decimals  
> back to you properly. When this was written it was used on a site  
> that dealt with a lot of currency values, so there might be something  
> else going on.

-Scott

---

<div class="post-metadata">

**Author:** ![ther](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/977dab/32.png) [@ther](https://www.ruby-forum.com/u/ther)\
**Post date:** [March 7, 2007, 7:39am UTC](https://www.ruby-forum.com/t/mssqlclient-returns-nil-for-money-decimal-numeric-fields/87860/3 "2007-03-07T07:39:22Z")

</div>

Scott wrote:

> On Mar 6, 6:49 am, Damjan R. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:
> 
> > Posted viahttp://www.ruby-forum.com/.  
> > The mssqlclient works well enough for a demo at this point, but is not  
> > fit for production. You should check out the source (http://  
> > [rubyforge.org/scm/?group\_id=2344](http://rubyforge.org/scm/?group_id=2344)) and fix the bugs before you stick it  
> > into a live site. I do know that it passed more tests than the built-  
> > in MSSql adapter, so it’s a little odd that it wont return decimals  
> > back to you properly. When this was written it was used on a site  
> > that dealt with a lot of currency values, so there might be something  
> > else going on.
> 
> -Scott

I am using last rails (1.2.2), ruby 1.8.5.

Browsing source won’t do no good because I don’t C.

by

TheR