Hi, there. I have an application running with sqlite in development mode
and production mode.  I just installed mysql on windows and created a
new database in mysql for the application in development mode.  After
putting some data in database, I found that I can't save Time object
like 'Tue Feb 01 12:34:56 UTC 2000" completely.  Mysql showed the time
only "12:34:26".  But sqlite is able to save it and convert it to
something like "2010-02-01 12:34:56".  I had to convert the Time object
before I saved it to database.
The other problem I encountered is storing long string in mysql.  I put
some long strings(about thousand characters) in one of the columns in a
table using sqlite without any problems.  When I did it with mysql, it
truncated the string by itself with less than 300 characters left.  It
did that on every long string in the table.  I did not change any ruby
code except the yml file.  Did I miss something?
Thanks in advance.
-- 
Posted via http://www.ruby-forum.com/.

-- 
You received this message because you are subscribed to the Google Groups "Ruby 
on Rails: Talk" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/rubyonrails-talk?hl=en.

Reply via email to