The SQL server 2000 books say this:
BM__nchar_and_nvarcharnchar and nvarchar Character data types that are either fixed-length (nchar) or variable-length (nvarchar) Unicode data and use the UNICODE UCS-2 character set. nchar(n) Fixed-length Unicode character data of n characters. n must be a value from 1 through 4,000. Storage size is two times n bytes. The SQL-92 synonyms for nchar are national char and national character. nvarchar(n) Variable-length Unicode character data of n characters. n must be a value from 1 through 4,000. Storage size, in bytes, is two times the number of characters entered. The data entered can be 0 characters in length. The SQL-92 synonyms for nvarchar are national char varying and national character varying. Try those for your column. --Eric -----Original Message----- From: Eric Gnagey [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 14, 2004 1:42 PM To: [EMAIL PROTECTED] Subject: [AspNetAnyQuestionIsOk] sql server 2000 limiting nvarchar column to 256 chars 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 <http://promotions.yahoo.com/new_mail> Yahoo! Groups Sponsor ADVERTISEMENT <http://us.ard.yahoo.com/SIG=129gd2n2e/M=295196.4901138.6071305.3001176/D=gr oups/S=1705006764:HM/EXP=1089913327/A=2128215/R=0/SIG=10se96mf6/*http:/compa nion.yahoo.com> click here <http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S= :HM/A=2128215/rand=575960371> _____ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/> * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED] e> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of <http://docs.yahoo.com/info/terms/> Service. [Non-text portions of this message have been removed] ------------------------ 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/
