Start Free Trial

asked on

text,varchar,ntext datatypes

Hi ,
i tried using text,nvarchar,varchar(8000),ntext etc datatypes to store large data.
but noticed that sql is storing around 1000 characters.
i tried to store thru VB appln, its same.
why is that so. any idea ???

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Guy Hengel [angelIII / a3]

I think you only get displayed 1000 characters...
I have saved up to 8000 caracters in (var)char, for TEXT the limit is 2GB, and is handled differently for large strings...

CHeers

47 questions asked, only 22 closed.... ADMINISTRATION WILL BE CONTACTING YOU SHORTLY.
This question appears to have been abandoned. Your options are:

1. Accept a Comment As Answer (use the button next to the Expert's name).
2. Close the question if the information was not useful to you. You must tell the participants why you wish to do this, and allow for Expert response.
3. Ask Community Support to help split points between participating experts, or just comment here with details and we'll respond with the process.
4. Delete the question. Again, you must tell the other participants why you wish to do this.

For special handling needs, please post a zero point question in the link below, include the question QID/link.
https://www.experts-exchange.com/jsp/qList.jsp?ta=commspt

Please click this Help Desk link for Member Guidelines, Member Agreement and the Question/Answer process: Click you Member Profile to view your question history and keep them all current with updates as the collaboration effort continues.
https://www.experts-exchange.com/jsp/cmtyHelpDesk.jsp

To view your open questions, please click the following link(s) and update/finalize them all.

https://www.experts-exchange.com/jsp/qShow.jsp?ta=crystal&qid=20223690
https://www.experts-exchange.com/jsp/qShow.jsp?ta=crystal&qid=20265178
https://www.experts-exchange.com/jsp/qShow.jsp?ta=crystal&qid=20265195
https://www.experts-exchange.com/jsp/qShow.jsp?ta=crystal&qid=20274444
https://www.experts-exchange.com/jsp/qShow.jsp?ta=crystal&qid=20275198
https://www.experts-exchange.com/jsp/qShow.jsp?ta=crystal&qid=20180838
https://www.experts-exchange.com/jsp/qShow.jsp?ta=mssql&qid=20133711
https://www.experts-exchange.com/jsp/qShow.jsp?ta=mssql&qid=20267928
https://www.experts-exchange.com/jsp/qShow.jsp?ta=mssql&qid=20272203
https://www.experts-exchange.com/jsp/qShow.jsp?ta=mssql&qid=20268833
https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20273717
https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20271488
https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20271453
https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20266279
https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20264617
https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20258796
https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20257478
https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20255754
https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20255748
https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20242197
https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20214627
https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20193125
https://www.experts-exchange.com/jsp/qShow.jsp?ta=asp&qid=20181410
https://www.experts-exchange.com/jsp/qShow.jsp?ta=asp&qid=20148274
https://www.experts-exchange.com/jsp/qShow.jsp?ta=asp&qid=20008099

PLEASE DO NOT AWARD THE POINTS TO ME.

------------> EXPERTS: Please leave any comments regarding this question here on closing recommendations if this item remains inactive another three days.

Thank you everyone.

Moondancer
Moderator @ Experts Exchange

P.S. For year 2000 questions, special attention is needed to ensure the first correct response is awarded, since they are not in the comment date order, but rather in Member ID order.

ASKER

the problem havent solved yet. since nigelrivett answered first alloting the points

ASKER

the problem havent solved yet. since nigelrivett answered first alloting the points

Thank you for returning and updating/finalizing your questions. Since this issue is not yet resolved, nigelrivett may wish to continue collaboration efforts with you, until you attain your goal. Should tht occur, let me know and I can change the grade to an A.

Thanks,

Moondancer - EE Moderator