We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Insert base64 string to SQL server table

Received Response
10
Views
3
Comments
edited Jan 18, 2021 3:45PM in Integration 3 comments

Summary

Insert base64 string to SQL server table

Content

Hi,

I am using OIC to expose rest service. the json input contains base64 string and I am trying to insert it to a SQL server table to column of type varchar(max).

in the table I see that the base64 string is truncated,  I think the adapter use nvarchar(max) which is 64K and not varchar(max) - (the column type in the table) which is 2GB

Any idea how to solve this ?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!