Read non-english text for SQL Server using ADO
Posted on 2004-08-25
The problem we're facing is text being automatically translated when retrieved from the database.
I.e., non-english characters are returned as question marks ("???").
We've looked around and found that ADO has a flag called "Auto Translate" which determines whether or not to automatically translate the text. The problem is that although this flag works great with string typed fields, it has no effect on memo typed fields. That is to say that memo typed fields are being translated regardless of the flag.
We've run two SQL statements, as follows:
- "SELECT MY_MEMO_FIELD FROM MY_TABLE" - Returns '???' instead of non-english characters.
- "SELECT SUBSTRING(MY_MEMO_FIELD, 1, 1000) FROM MY_TABLE" - Returns the correct characters.
Is there some solution for the problem?