Solved

SQL TEXT LIMIT

Posted on 1998-10-13
6
348 Views
Last Modified: 2009-12-16
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?
0
Comment
Question by:HBence
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 

Author Comment

by:HBence
ID: 1090534
.
0
 
LVL 7

Expert Comment

by:spiridonov
ID: 1090535
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
 

Author Comment

by:HBence
ID: 1090536
Edited text of question
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:HBence
ID: 1090537
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
 
LVL 7

Expert Comment

by:spiridonov
ID: 1090538
What do you use to insert/seect?
0
 
LVL 1

Accepted Solution

by:
snydero earned 50 total points
ID: 1090539
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

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question