SQL TEXT LIMIT

I am a university student working with a SQL Database. I want to insert text containing 2000 characters into a text field. The text field doesnt allow 2000 characters. How can I fix this?
HBenceAsked:
Who is Participating?
 
snyderoConnect With a Mentor Commented:
To enter text data, the column must first be initialized. Initialization causes a 2K data page to be allocated.
Initialize the text column by providing non-null data with an INSERT statement or any value (including a NULL) with an UPDATE statement. Then use the READTEXT statement to read text data, the WRITETEXT statement to replace text data, and the UPDATETEXT statement to modify text or image data.

0
 
HBenceAuthor Commented:
.
0
 
Victor SpiridonovCommented:
What do you mean by "doesn't allow". Plase be more specific on how you are trying to do this. Detailed description of the problem   will help us to solve your problem quicker
0
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

 
HBenceAuthor Commented:
Edited text of question
0
 
HBenceAuthor Commented:
I inserted the text without any problems. When I tried to view it with a SELECT statement, only some of the text was returned.
The SET TEXTSIZE statement didn`t help much either.
0
 
Victor SpiridonovCommented:
What do you use to insert/seect?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.