DB2 version 7 and before limit for table/column/alias is 18 chars.  Version 8 forwards is 30 for column/alias and 128 for tablenames.  Not sure why IBM did it that way...

On 3/16/06, Michael Schoen <[EMAIL PROTECTED]> wrote:
Rick Olson wrote:
> Should Oracle have a special aliasing method that converts that to
> j_c_posts?  Should all databases do that consistently?  I'd really
> like to have readable aliases and get away from something like
> j_c_posts_2.

Do other dbs have a length limit on aliases? Oracle's is 30 chars.

_______________________________________________
Rails-core mailing list
Rails-core@lists.rubyonrails.org
http://lists.rubyonrails.org/mailman/listinfo/rails-core

_______________________________________________
Rails-core mailing list
Rails-core@lists.rubyonrails.org
http://lists.rubyonrails.org/mailman/listinfo/rails-core

Reply via email to