Large Json data storing in db column

Transact-SQL
1

Hi,

Have a table to store color details in json format and have data about length 45,000.

Gave column type varchar(max), but seems to be data not getting fully saved. When checked the length of data inserted found to be 43679. Tried giving data type text also,but no use.
Not getting any sql error of truncated.
Any idea why data not getting inserted.

2

Varchar(max) should be able to handle that. When you query it with json, does it return the proper data?

3

How are you determining the length of the JSON data is 'about' 45,000? Isn't 43679 'about' 45,000?

1 Like
4

Is this for microsoft sql server
If data is for color details why is it so big

What kind of json data is it