-6

I have set varchar to 8000 but still not able to store more than 255 character in sql server.

Gulshan nayak
  • 3
  • 1
  • You need to provide more information – Mazhar Feb 23 '18 at 10:38
  • I have read question and can only assume bug in sql server. – TDP Feb 23 '18 at 10:49
  • @TDP this is unlikely to be a bug, and more likely to be user misunderstanding. We have far too little information, however, to give any type of valid answer to this question. To the OP, please update your post; have a look at [How to create a Minimal, Complete, and Verifiable example](https://stackoverflow.com/help/mcve) on how to post a qusetion properly. Thanks. – Thom A Feb 23 '18 at 11:01
  • @Larnu - It was an attempt at humour... – TDP Feb 23 '18 at 12:14

1 Answers1

0

The issue looks that the insertion should be a success but while retrieving through the QA, you see only 255 characters back. This is just a visual problem and nothing more. Just change this limitation under the Tools > Options > Results in the SSMS where you have an option to change the Maximum characters per column option. Try changing to the desired value. Hope this helps!

Piyush Bhasin
  • 144
  • 7