Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Image Binary Data to Image

Hello,   I have a table in SQL Server which has Image binary data in the below format -      0x1F8C0200B28C010064 0x1F8C0200DE720100CC 0x1F8C0200DE720100CC 0x1F8C0200B28C010064 0x1F8C0200B28C01...
Need Help
  • Icey's avatar
    Icey
    5 years ago

    Hi Anonymous ,

     

    Please check if the method in this blog could help you.

     

    Step 7

    Change the data type of ImageData (Binary) column to text from the top panel's Transform tab.

     

    Step 8

    Go to "Add Column" and click on "Custom Column". It will open a window. Enter the column name and formula given below and click OK.

    “data&colon;image/<image_format>;base64,”&[ImageData<binary_column_name>]

     

    Step 9

    On Data tab, select Image column and change its data category to Image URL.

     

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

AlexisOlson There is something I noticed, when I am using the function and encoding into base64 I am getting something like this
H4wCAMU6AADNuWVQHEDXJjpA8ABJCO7ungGCBncL7u7ubiFY

 

Whereas if I use the same image and convert the image itself to base 64  the value is - 

iVBORw0KGgoAAAANSUhEUgAAAV0AAAEOCAIAAACl8FO5AA