https://answers.axonivy.com/questions/325/how-to-write-a-file-as-into-a-database-field-of-type-varbinary<p>I would like to write a File in a varbinary field of a database table. How do I implement this?</p>enThu, 23 Jan 2014 10:24:42 -0500https://answers.axonivy.com/questions/325/how-to-write-a-file-as-into-a-database-field-of-type-varbinary/494<p>I remember that I've done this in ivy 3.x</p> <ol> <li>Load the file into a ivy-attribut with type File</li> <li>Encode the file in a String Attribut --&gt;in.Temp.str3 = in.File.Bild.getFileContentBase64Encoded()</li> <li>Write a Sql-Query in DB-Step UPDATE FileTable SET file=CAST(in.Temp.str3 as varbinary(MAX))</li> </ol>Raphael BürginThu, 23 Jan 2014 10:24:42 -0500https://answers.axonivy.com/questions/325/how-to-write-a-file-as-into-a-database-field-of-type-varbinary/494https://answers.axonivy.com/questions/325/how-to-write-a-file-as-into-a-database-field-of-type-varbinary/491<p>In Xpert.ivy 5.x, does it support for this?</p>nndiepWed, 22 Jan 2014 12:29:07 -0500https://answers.axonivy.com/questions/325/how-to-write-a-file-as-into-a-database-field-of-type-varbinary/491https://answers.axonivy.com/questions/325/how-to-write-a-file-as-into-a-database-field-of-type-varbinary/326<p>At the moment it is not easily possible with Xpert.ivy 3.x. You can write an own PI to implement this.</p>Reto WeissWed, 03 Feb 2010 03:25:35 -0500https://answers.axonivy.com/questions/325/how-to-write-a-file-as-into-a-database-field-of-type-varbinary/326