CODEWITHSUNDEEP
sqlbase64varcharmax
GalloPinto
GalloPinto

Reputation: 677

Saving more than 111305 characters in varchar(MAX) SQL 2012

As the title says, I'm trying to save a PDF converted to base64 in SQL varchar(MAX) column. When my example PDF is converted to base64, is a 111305 characters length string. I copy and paste that string to SQL varchar(MAX) column, but when I do a select * from table, and copy the data, it's only a 43120 characters string.

So it's looks like SQL cut by half my string

So the question is: "How can i save a 111305 characters length string or more in SQL?" "Is varchar(MAX) correct for this?"

POSTDATA: I cannot save the PDF to binary because to save it to the database in the webapp it uses a web service, and if I send binary data to the web service it doesn't not acept it. Help please.

Upvotes: 0

Views: 566

Answers (0)

Related Questions