Data Type Char. Limitations????
Posted on 2005-05-03
As far as I "know" an nvarchar is the MAX character holder in SQL. Am I correct? With a max lengh of 4000 char. I have a project going on, where a majority of the time, the values will not exceed 4000, however, in beta testing for over 2 weeks with the end users, I finally had a dump into SQL exceeding 4000. Is there any other Data Type that will allow SQL to exceed 4000 char, so I don't run into this down the road?