varchar max is 8000 characters, you can edit the default 256 to whatever you need up to that.
--- Eric Gnagey <[EMAIL PROTECTED]> wrote: > Does anyone know if there is a default that needs to > be change in Enterprise Manager to allow more than > 256 > chars in a column. I have tried using text, > nvarchar, > and char data types, but the all only allow 256 > chars. > I am trying to create a column that will hold about > 4000 chars (multi-line text field on a web form). > > Thanks in advance! > > > > > > __________________________________ > Do you Yahoo!? > Yahoo! Mail is new and improved - Check it out! > http://promotions.yahoo.com/new_mail > __________________________________ Do you Yahoo!? New and Improved Yahoo! Mail - Send 10MB messages! http://promotions.yahoo.com/new_mail ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
