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). 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
