1

I am storing some Unicode data(text) in sql server in table definition i have nvarchar(max) which I guess have capacity to store 2^31 characters.

When I store 696829 Unicode characters it saves only 43 thousands(43679) characters only.

Noel Evans
  • 8,113
  • 8
  • 48
  • 58
Fahad Malik
  • 21
  • 2
  • 3
    Can you please post your table schema and a small repro – TheGameiswar Oct 04 '16 at 08:02
  • 5
    please google '43679 characters in sql server'. There are lots of posts around there. – Esty Oct 04 '16 at 08:13
  • People seem to have found success by using the MS advised varchar .. [here](http://stackoverflow.com/questions/33495535/not-able-to-save-more-than-43679-char-in-text-datatype-column-in-sql-server) – blackpen Oct 04 '16 at 08:19
  • 2
    Confirm with SELECT LEN(fieldname) FROM table..., not cut and paste from SSMS. – smoore4 Oct 04 '16 at 08:21
  • This [link](http://stackoverflow.com/questions/12639948/sql-nvarchar-and-varchar-limits) will be useful. – Unnikrishnan R Oct 04 '16 at 08:31
  • thank you guys for help :) i figured it out by seeing this https://mnaoumov.wordpress.com/2015/02/18/sql-server-management-studio-and-very-large-strings/ – Fahad Malik Oct 04 '16 at 09:00

0 Answers0