Solved

store more than 4000  charecters  in a single column in sql server 2008 r2  ??

Posted on 2014-01-18
4
448 Views
Last Modified: 2014-01-19
Hello expert,
how to store more than 4000  charecters  in a single column in sql server 2008 r2??


Thanks
Thomos
0
Comment
Question by:deve_thomos
4 Comments
 
LVL 70

Assisted Solution

by:Éric Moreau
Éric Moreau earned 250 total points
ID: 39791123
set its type to varchar(max)
0
 
LVL 38

Accepted Solution

by:
Jim P. earned 250 total points
ID: 39791290
Well if you want to go to 8000 then change it from nvarchar(4000) to varchar(8000). Or go to varchar(max) as Eric suggested.
0
 

Author Closing Comment

by:deve_thomos
ID: 39791985
Thanks a lot...
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

776 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