ASE Database forum - Re: change column type-->warning: row size(2121 bytes) could exceed row size limit,which is 1962

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: change column type-->warning: row size(2121 bytes) could exceed row size limit,which is 1962

Michael Peppler

2005-10-27, 8:21 am

On Tue, 11 Oct 2005 19:44:58 -0700, j wrote:

> when i try to change column type, i get this warning. how to change the
> row size limit ? is it possible to disable row size check ? coz in mysql
> we dont have the constraint of table size. thank you for clarriying.

The max row size depends on the page size as a row (except for
text/image data) has to fit on a single page.

You can't turn off the warning, AFAIK.

You can rebuild your DB server with a larger page size (4k, 8k or 16k) if
you need wider rows.

Note that data will still get inserted to the oversized row, as long as
the total width of actual data is less than the row size.

Michael
--
Michael Peppler [TeamSybase] mpeppler@peppler.org - http://www.peppler.org/
Sybase DBA/Developer
Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html

Sponsored Links