ActiveRecord::StatementInvalid

Rails
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

2

On 13 January 2011 06:44, Tom M. [email protected] wrote:

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

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

Thanks for your reply. Meanwhile I have done it.

5

Quoting Tom M. [email protected]:

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