Solved

Read non-english text for SQL Server using ADO

Posted on 2004-08-25
5
244 Views
Last Modified: 2010-04-05
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?

0
Comment
Question by:Slavak
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 Comments
 
LVL 17

Expert Comment

by:Wim ten Brink
ID: 11895451
Yes, use widestrings... (Unicode)
0
 
LVL 3

Author Comment

by:Slavak
ID: 11895479
where?
0
 
LVL 6

Accepted Solution

by:
bpana earned 500 total points
ID: 11895904
all the controls in your application should support WideString and you have to use WideString in place of String type.

there is a free set of unicode controls I used which are prety nice:
http://tnt.ccci.org/delphi_unicode_controls/
0
 
LVL 3

Author Comment

by:Slavak
ID: 11906250
the problem is not delphi gui controls, problem is that ADO attempts to translate the text and fails.

is it possible to get the text from memo field without translation?
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question