Database row with bytes

Help Studio
, ,
1

I have a database which contains binary data as system.bytes. I can convert the content with a powershell into a binary file but I didn’t get the value of the content as a readable variable:
image

But to put the content to a file or pass it as parameter it only says: “System.Byte”
image

Here it says that I’m not allow to write
So I have added “tostring”:
image
but the out put stays with “System.Byte”. All tries with convert oder ctype were not successful
image
This will give a the output “System.Byte” but not the content.
Please help to get at least the byte array write as text to a file.

2

Why don’t you use File.WriteAllBytes() to save it to a file? You can call the method using Invoke Method or Invoke Code.

3

Hi,

Probably, It’s Zlib compressed data. What is original data type?

First, decompress the byte array using ZlibStream class. Then handle the result by proper way depending on original format.

Regards,

4

Thanks for your support. But even if it’s zipped, it’s still a byte-array variable, right? I don’t have any issues to get the content out of it, but I need to get the content to pass it into a file or as a parameter for my PS1, which will convert each byte into a char (which works when I copy the content manually by my SQL console).

5

file.writeAllBytes:
error BC30512: “Option Strict On” does not allow convert (translated) “Object” in “Byte()”.

6

Hi @TP2B ,

Can you check below codes in immediate window,
System.Text.Encoding.Default.GetString(CurrentRow.item(2).ToString)

System.Text.Encoding.UTF8.GetString(CurrentRow.item(2).ToString)

System.BitConverter.ToString(CurrentRow.item(2).ToString)

Let us know if you still have any issue?

1 Like
7

Have you tested to cast it to byte array first?

File.WriteAllBytes(testFile, DirectCast(CurrentRow.Item(2), Byte()))
8

The following errors were encountered while processing the workflow tree:
‘VisualBasicValue’: Compiler error(s) encountered processing expression “File.WriteAllBytes(“c:\buffer\infu.txt”, DirectCast(CurrentRow.Item(2), Byte()))”.(2) : error BC30491: Expression does not produce a value.

image

9

Have you run the code? The function doesn’t return any result so you can’t use it in the Immediate pane.

10

image
image804×132 3.16 KB

image
image802×223 6.05 KB

image
image811×126 3.26 KB

11

like this?

image
image757×256 26.6 KB

What type of variable should I use?

1 Like
12

CurrentRow should be of type DataRow.

13

Thanks for support. But clear how to manage:
code:
File.WriteAllBytes(“C:\buffer\inu1.txt”, DirectCast(CurrentRow.Item(2), Byte()))
Argument: ?

image

same problem?

14

No need for other arguments. Just change the type of CurrentRow from Object to DataRow and then you should be able to run the code as is.

15

The type should be DataRow, not String.

16

that looks much better now!
image
but it’s a matter of encoding I think

17

any idea how to get it as this:
image

18

It’s a binary file so it won’t look good when you open it as a text file. Do you know what kind of data it is? E.g. if it’s a pdf, you could test to change “.txt” to “.pdf”.

19

If you just want the numbers, you can use String.Join():

String.Join(", ", DirectCast(CurrentRow.Item(2), Byte()))
20

Thank you very much, I will still have to work on. When I copied the bytes from SQL I was able to convert and got a rtf file. But a RTF looks very different as to the screen I shared before.
image