The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

MarcR's avatar
MarcR
Contributor II
4 years ago

Read/ Analyze contents of Binary columns

Hi there,  For a client i want to do a detailed analysis of the data (numbers) in the database. We want to investigate the percentage of numbers < 0.01. However, when i use the Data records i see t...
planning
MarcR's avatar
MarcR
Contributor II
4 years ago

Hi Christian, I used the FDX, but am still curious if we can get the value out 😉

Usually in SQL binary is used for documents and images. In this case i think the column contains a table. Therefore you cannot open it as a decimal (or a varchar). There should be an option to loop through the fields in the column and get their value. But its not urgent anymore, issue is solved but my curiosity is not satisfied 😉

  • ChristianW's avatar
    ChristianW
    Icon for OneStream Employee rankOneStream Employee
    4 years ago

    Hi Marc

    Out of curiosity, I played around with it and I could identify some patterns, but the byte order was different (left to right instead of right to left) so I assume, the conversion takes place in .Net and not in SQL. As a result, I doubt, there is a simple select statement for the job.

    Cheers

    Christian