ActiveRecord::StatementInvalid

rubyonrails-talk
1

Hi    I am using rails2.2.2 with mysql5.1. I have a text field 'EmailBody'. And when I try to store data more than 65536 (Say for example 65550) in linux it works properly by truncating it to 65536 characters and save successfully to table. But when I test this same application on a windows machine I get the error ActiveRecord::StatementInvalid. I am attaching the error I am getting on a windows machine. Is it a adapter prblem. Please help

Thanks in advance

Attachments: http://www.ruby-forum.com/attachment/5733/inbox.htm

2

I don't know the cause of the problem (possibly a bug or inconsistency in the adaptor as you suggest), but in terms of getting your application running can you not just truncate the string to a valid length before saving the record?

Colin

3

but in terms of getting your application running can you not just truncate the string to a valid length before saving the record?

     Yes that is possible any way not the best. Relating to this two questions. 1) Is there any other gem than mysql. I found ruby-mysql but could not try since it requires ruby >= 1.8.7 . Mine is 1.8.6 2) In mysql what is the next option than a text field that handles very large data

Thanks

4

Quoting Tom Mac <lists@ruby-forum.com>:

> but in terms of getting your > application running can you not just truncate the string to a valid > length before saving the record?

     Yes that is possible any way not the best. Relating to this two questions. 1) Is there any other gem than mysql. I found ruby-mysql but could not try since it requires ruby >= 1.8.7 . Mine is 1.8.6 2) In mysql what is the next option than a text field that handles very large data

    t.text "description", :limit => 16777215

This in MySQL creates a MEDIUMTEXT field with a 24-bit length. There is also a LONGTEXT type with 32-bit lengths. The default is 16-bit lengths.

HTH,   Jeffrey

5

Thanks for your reply. Meanwhile I have done it.