Unicode characters in Recordset
am 07.11.2007 08:44:20 von Chris
In my Access table I keep characters other than English (Bulgarian,
Russian etc)
If I export my query with TransferText I am able to see the non-
English characters in the text files.
If I get the query's results with OPENRECORDSET and then write the
values as below
Print #1, """"; Trim(dst_ITM.Fields(i).Value); """";
I get "?????????????" instead of correct characters. Even the
dst_ITM.Fields(i).Value returns "???????????" characters while query
opened in Access returns correct ones. Can unicode be applied in this
case ?
Can this be avoided ?
Thanks a lot!!
Re: Unicode characters in Recordset
am 07.11.2007 15:50:07 von OldPro
On Nov 7, 1:44 am, Chris wrote:
> In my Access table I keep characters other than English (Bulgarian,
> Russian etc)
>
> If I export my query with TransferText I am able to see the non-
> English characters in the text files.
>
> If I get the query's results with OPENRECORDSET and then write the
> values as below
> Print #1, """"; Trim(dst_ITM.Fields(i).Value); """";
> I get "?????????????" instead of correct characters. Even the
> dst_ITM.Fields(i).Value returns "???????????" characters while query
> opened in Access returns correct ones. Can unicode be applied in this
> case ?
>
> Can this be avoided ?
>
> Thanks a lot!!
If you are trying to output to a file, use the CreateTextFile method
of the FileSystemObject. It has a unicode option.