Yes - the create statement includes VARCHAR2(4000).
As Ola points out (which I was afraid of) the adapter will default to
the biggest size allowed. Interestingly only the Oracle implementation
in activerecord-jdbc-adapter does this. Most others choose 255 as the
default.
Thanks for the insight.
On Dec 11, 2008, at 8:28 AM, Nick Sieger wrote:
I don't think activerecord-jdbc has anything to do with default sizes,
they should be baked into AR's migrations. Is the SQL sent to the
database actually specifying varchar2(4000)?
/Nick
On Thu, Dec 11, 2008 at 8:20 AM, Clint Hill <[EMAIL PROTECTED]
> wrote:
I'm not sure if this is the best place for this question (so
redirect if
not) but I was wondering about the String default from the
activerecord-jdbc-adapter.
When using Oracle the default for string seems odd.
create_table :accounts do |t|
t.string :name
end
This will create a column VARCHAR2(4000). I can set the :limit to
255 but I
was curious - why doesn't it do this automatically?
---------------------------------------------------------------------
To unsubscribe from this list, please visit:
http://xircles.codehaus.org/manage_email
---------------------------------------------------------------------
To unsubscribe from this list, please visit:
http://xircles.codehaus.org/manage_email
---------------------------------------------------------------------
To unsubscribe from this list, please visit:
http://xircles.codehaus.org/manage_email
