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
Skip to content
  • Register

    • Insert base64 string to SQL server table

    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!