[AccessD] Unicode string conversion

For the eddification of the curious, the solution turned out to take two
steps:

1. Convert the binary field to a unicode string: MyString =
StrConv(MyBinaryField,vbUnicode)
2. Convert the output from step 1 to to a standard string: MyFinalString =
StrConv(MyString,vbFromUnicode)

(done in one double step in code)


On Mon, Apr 6, 2009 at 8:08 AM, Gustav Brock <Gustav at cactus.dk> wrote:

> Hi Doug
>
> I think you need to use a recordset and the GetChunk method to retrieve the
> data from the binary field.
>
> Look up the on-line help for an example of this.
>
> /gustav
>
>
> >>> dbdoug at gmail.com 06-04-2009 16:44 >>>
> It's a SQL varbinary field and I'm reading it from a SQL table linked to my
> Access db.
>
> I tried the 'vbFromUnicode' parameter as well, but it gave me '??' as the
> result from the same field.
>
> Doug Steele
>
>
>