Doug Steele
dbdoug at gmail.com
Mon Apr 6 10:52:11 CDT 2009
OK, I will check this out. Thanks. 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 > > > On Sun, Apr 5, 2009 at 12:29 PM, Stuart McLachlan <stuart at lexacorp.com.pg > >wrote: > > > Shouldn't that be > > StrConv(myFredString,vbFromUnicode) > > > > > > On 5 Apr 2009 at 11:51, Doug Steele wrote: > > > > > Hello All: > > > > > > I have to read a unicode string from a SQL database into Access. The > bytes > > > are doubled up; for instance, the string for 'fred' in hex is > > > '6600720065006400'. > > > > > > I found the Access function 'StrConv', which almost does the > translation, > > > but leaves a blank after each character: > > > > > > StrConv(myFredString,vbUnicode) = 'f r e d '. > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >