Hello,

I ran into an issue where if I declaire

t.binary :col_name, :limit => 1.gigabyte

and use activeecord-jdbc-adapter to translate this to SQL. For MySQL and DB2, it is fine. But for oracle, I got a data type like " blob(1073741824)" which is incorrect in Oracle.

In jdbc_adapter I can see some code like sql_str += "(#{limit})" if limit

 

My app is supposed to run against different DBMS, including Oracle. So I guess my question is that should I worry about this in my app to check the adapter I use and avoid to use :limit option when it's Oracle. Or should activerecord-jdbc-adapter

should smartly avoid adding limt when it's Oracle.

 

Thanks

 

Yi

_______________________________________________
Jruby-extras-devel mailing list
[email protected]
http://rubyforge.org/mailman/listinfo/jruby-extras-devel

Reply via email to