Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
1 reply
Subscribers
8 subscribers
Views
1942 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Hello, I am trying to insert the document binary data from Appian to
vinitl522
A Score Level 2
over 8 years ago
Hello,
I am trying to insert the document binary data from Appian to MS SQL DB. I am using Query Database smart service.
And used the below statement:
CONVERT(varbinary(max),ac!Attachment)
ac!attachment is of type text which holds data as:
546573743132330D0A48656C6C6F0D0A48690D0A686F772061726520796F750D0A
whereas in DB It is storing the binary data as:
350034003600350037003300370034003300310033003200330033003000440030004100340038003600350036004300360043003600460030004400300041003400380036003900300044003000410036003800360046003700370032003000360031003700320036003500320030003700390036004600370035003000440030004100
Can you please let me know how we can make sure that the binary data remains same in MS SQL server.
Regards,
Vinit.
OriginalPostID-224460
OriginalPostID-224460
Discussion posts and replies are publicly visible
0
vinitl522
A Score Level 2
over 8 years ago
The primary key in the table is unique identifier so we cannot use write to data store entity.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel