Solved

Read non-english text for SQL Server using ADO

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

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

706 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now