tedb_at_nc.rr.com wrote:
> 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
In terms of storage none. In terms of data integrity: Huge.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Thu Jun 02 2005 - 19:23:02 CDT
