Use bigint instead of int

From money_field_settings() (the implementation of the hook_field_settings() CCK hook):

    case 'database columns':
      $columns['amount'] = array(
        'type' => 'int',
        'length' => 13,
        'not null' => TRUE,
        'default' => 0,
        'unsigned' => FALSE,
      );
      $columns['currency'] = array('type' => 'varchar', 'length' => 3);
      return $columns;

As you can see, I've set the amount to be integers of length 13. The last two of those are used for decimals, which leaves you with 11 symbols left, enough for almost 100 billion. Seems enough to me.

However, when I try the amount you suggested (fifty million), it is processed to somehow be -1. I'll have to figure out why that happens.

A patch is welcome, of course :)

Excellent! Looking forward to get to know about the cause of this. I tested this:

echo 50000000/100;

And that worked just fine. So it's not that PHP can't handle numbers that big (which would be silly too).

That's it!

2147483648
versus
5000000000 (50 million * 100 cents)

That's almost twice as big as the allowed size. Sigh. I set it to bigint, keeping the same length (13), and voila, it worked. At least, I could get it working in MySQL. Now it won't work in PHP, or Drupal, or CCK. SIGH! I hope you can continue your search now.

You're probably right. I'll have to look at it more in-depth though, to confirm that that's the cause. If you'd like to help narrow down the cause, start looking in the code that handles the DB interaction.

I've now configured the database definition to use bigint. If you encounter any problems, please open a new issue.