Solved

Read non-english text for SQL Server using ADO

Posted on 2004-08-25
5
241 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
  • 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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

810 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