Binary

[vbgladiator]

I have a field in a database that is stored as binary.
I retrieve it into a string variable. How can I read it?

[jim mcnamara]

Most binary data is the memory representation of a datatype, like double, for example, or a UDT

What datatype(s) is this supposed to be?

[vbgladiator]

It is a datatype.

I want to know how I can read it from a string as oppose to from a file. If I use the open statement I get a file not found error.

Thanks,

[DiGiTaIErRoR]

You should use a byte array to read it.

Dim ByteAry() as Byte
Dim strRet as String
 
'todo: read into ByteAry
 
'use Str Conversion to turn ACSii, into unicode(B-STR)
strRet = Strconv(ByteAry, vbUnicode)

[vbgladiator]

But how do I read it into a bytearray?
I have the value in a string variable.

[DiGiTaIErRoR]

Originally posted by vbgladiator
But how do I read it into a bytearray?
I have the value in a string variable.

Uhm. If you're inputing a string into a database it's going to take twice the space.

You do it like you use a string. It's easy.

[vbgladiator]

No, I have the value in a memo field in an access database.
I retrieve the value into a string variable.

now, I need to be able to read it. It is used to pass it into a C dll but I need to read it in VB

Thanks,