[AccessD] Unicode string conversion

Doug Steele dbdoug at gmail.com
Sun Apr 5 13:51:12 CDT 2009


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 '.

I'd prefer not to have to step through every string dropping the spaces.
Does anyone know of a more elegant way to do this?

Thanks,

Doug Steele



More information about the AccessD mailing list