On Mon, 2004-02-02 at 03:10, Tim Bunce wrote: > On Sun, Feb 01, 2004 at 04:16:44PM -0800, Michael Peppler wrote: > > On Sun, 2004-02-01 at 13:33, Tim Bunce wrote: > > > Which databases cannot accept, and do something reasonable, with a > > > VARCHAR field declaration of 1024 characters? > > > > Sybase < 12.5 will throw an error on the create statement, and will > > probably fail on the insert as well (though I don't have a server > > running here right now that I can test it on). > > > > Sybase >= 12.5 will handle the 1024 limit with no problems, although you > > will get a warning message if the total width of the table could exceed > > the page size (2k by default, but configurable up to 16k). > > Thanks. Do you (or anyone else) know if the same issues apply to MS SQL?
Sorry, no. Michael -- Michael Peppler Data Migrations, Inc. [EMAIL PROTECTED] http://www.mbay.net/~mpeppler Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or long term contract positions - http://www.mbay.net/~mpeppler/resume.html
