Rails <-> MySQL

Hi there,

I have this table "friendships" and it contains the 2 columns:
- fsrq_sender_id
- fsrq_receiver_id

When I tell Rails to create a record, the log file says (correctly, it
seems to me):
INSERT INTO `friendships` (`fsrq_sender_id`, `fsrq_receiver_id`)
VALUES(139, 140)

But when I check the new database record, both of the fields hold the
value '127' (instead of '139' and '140').

How can this be???

Thanks a lot for any help with this strange thing!
Tom

Hi there,

I have this table "friendships" and it contains the 2 columns:
- fsrq_sender_id
- fsrq_receiver_id

When I tell Rails to create a record, the log file says (correctly, it
seems to me):
INSERT INTO `friendships` (`fsrq_sender_id`, `fsrq_receiver_id`)
VALUES(139, 140)

But when I check the new database record, both of the fields hold the
value '127' (instead of '139' and '140').

How can this be???

Odds are the fields in that table are using TINYINT which has a maximum value of 127. What's the schema for that table?

-philip

Thanks, Philip! That was exactly it!

Good to have guys like you...
Tom