locked
Binary data RRS feed

  • Question

  • Dear friends,

    is there some possibility to show in field with binary/varbinary data type true binary data (instead of announcement <binary data>)?
    Thank you very much for response.
    Anna

    Wednesday, October 24, 2018 2:54 PM

Answers

  • Dear friends,

    I found out it.
    1. If I used LM Button and choosed "Edit Top 200 Rows" - Data are showed as <binarydata>.
    2. If I prepared query: Select * From table - Data are showed as true binary data.
    Unbelievable! :)
    But of course, I must not change binary data directly in cells....
    Anna


    Always recommended to use query editor to use SELECT query to display data. Dont use grid UI as there's a chance of accidentally messing with data

    Please Mark This As Answer if it solved your issue
    Please Vote This As Helpful if it helps to solve your issue
    Visakh
    ----------------------------
    My Wiki User Page
    My MSDN Page
    My Personal Blog
    My Facebook Page

    Wednesday, October 24, 2018 4:18 PM

All replies

  • Dear friends,

    I found out it.
    1. If I used LM Button and choosed "Edit Top 200 Rows" - Data are showed as <binarydata>.
    2. If I prepared query: Select * From table - Data are showed as true binary data.
    Unbelievable! :)
    But of course, I must not change binary data directly in cells....
    Anna


    • Edited by Anna1313 Wednesday, October 24, 2018 4:02 PM
    Wednesday, October 24, 2018 3:55 PM
  • Dear friends,

    I found out it.
    1. If I used LM Button and choosed "Edit Top 200 Rows" - Data are showed as <binarydata>.
    2. If I prepared query: Select * From table - Data are showed as true binary data.
    Unbelievable! :)
    But of course, I must not change binary data directly in cells....
    Anna


    Always recommended to use query editor to use SELECT query to display data. Dont use grid UI as there's a chance of accidentally messing with data

    Please Mark This As Answer if it solved your issue
    Please Vote This As Helpful if it helps to solve your issue
    Visakh
    ----------------------------
    My Wiki User Page
    My MSDN Page
    My Personal Blog
    My Facebook Page

    Wednesday, October 24, 2018 4:18 PM