Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Does varchar2 size matter?

Does varchar2 size matter?

From: <tedb_at_nc.rr.com>
Date: 2 Jun 2005 16:35:36 -0700
Message-ID: <1117755336.926421.181090@f14g2000cwb.googlegroups.com> 





What are the repercussions of declaring all strings varchar2(255) even
if many will have lengths <=20 or <=30 (but none >255)?



Is there any value declaring some to be varchar2(20) or varchar2(30)
rather than just making them all varchar2(255)?



I'm converting a MySQL database to Oracle. By default MySQL accepts
strings too long and overwrites memory, which is okay as long as the
memory is unusued, but becomes a problem when it overwrites used
memory.



Thanks,


Ted Bogart
Received on Thu Jun 02 2005 - 18:35:36 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US