Stuart McLachlan
stuart at lexacorp.com.pg
Sun Apr 5 14:24:45 CDT 2009
How are you getting and reading the string? Access/Jet uses Uniode by default for storing strings. 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 '. > > 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 > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com