SQL Server data storage

V

Vijay Neelam

I have problem with SQL Server text storage. I'm not able to store 255 chars
in text field.
Does any body please tell me is there any way to store large text > 100000
chars boths storing and retriving..
thank you
Viajy
 
B

BJ Freeman

I assume your are using ms-sql SERVER.
If so the largest varchar is 8000
You have to use ntext with a maximum length of 230 - 1 (1,073,741,823)
characters.
Look up your BOL it will help you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CHAR(13) in ADP Report Problem 4
SQL Sentence from Text File 1
Exporting query or report to Excel results in Text field data loss 8
HOW TO MAKE CONNECTION ON SQL SERVER USING MS ACCESS AS A PLATFORM 4
function sort order 3
Caching dictionary in local drive 3
Maximum field size 12
Determining field type CHAR vs VARCHAR 3

Top