Solved

Read non-english text for SQL Server using ADO

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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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…
In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses
Course of the Month7 days, 11 hours left to enroll

632 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