Hi Guys ,
i have files which are of different sizes.How can i insert a text file which has more than 4000 characters in database .My table field is of type nvarchar so i cannot have more than 4000 characters ,is there a way around?
sadhawan
0
Light Poster
Recommended Answers
Jump to PostChange your field type to ntext or nvarchar(MAX), depending on which database you are using. If you regularly go over the 8KB limit, an alternative strategy is a good idea because the overflow paging of exceeding the limit with ntext or nvarchar(MAX) can have significant overhead.
Edward wrote a …
All 2 Replies
Reply to this topic
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.