I have a database set loop where the results are being saved to a TXT file. Works all fine. However, some output is:
And it should be this:"9038926B ?????????? ?? ??????? item name"
The data in the database is correctly saved (with the Russian text), so for sure, this is a characater set issue. In my SQL connection string, I've played a lot of with9038926B Инструкция по монтажу item name
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog={SQLCat};Data Source={SQLSERVER};Charset=ANSI;
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog={SQLCat};Data Source={SQLSERVER};Charset=UTF8;
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog={SQLCat};Data Source={SQLSERVER};Charset=UTF-8;
and all other types, but the outcome is still with the "?" signs.
Also adding
for example didn't help.SELECT * FROM [{SQLCat}].[Dev].[ServiceAppView] WHERE FileId = 24345
CONVERT TO CHARACTER SET utf8
Any suggestions?