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?
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
> 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.