Getting Unicode text from Access

Getting Unicode text from Access

Post by John Baim » Sat, 13 Sep 2003 19:12:34


I would like to get Unicode text from an Access database. Do I have to
use a WideString to get the text or how does that work?

John
John Baima
 
 
 

Getting Unicode text from Access

Post by E.Klei » Sun, 14 Sep 2003 18:54:47

get a value like this:
AdoQuery.FieldByName('ID_Name').value;
do not use
AdoQuery.FieldByName('ID_Name').asString;


"John Baima" < XXXX@XXXXX.COM > schrieb im Newsbeitrag

 
 
 

Getting Unicode text from Access

Post by Bojan Miju » Wed, 08 Oct 2003 03:17:11

Hi folks,

I have the same problem as mentioned below - my version of Delphi7 simply
doesn't retrieve unicode text from MDB file.

One of my projects is in testing-migration phase from D6 (where it was
originally developed) to D7. Guess what: D6 is able to get and set unicode
data to MDB but not D7! Just to mention that I'm using native VCL
components, not any third-party unicode extension set.

Anyway, that's just a small part of the huge nightmare I have had with the
migration. DFM files with unicode content (created and saved from D6) were
loaded by D7 as *** (e.g. none of the unicode data was shown properly). I
had to convert DFMs from D6 to text and then import them to D7, again, as
text - to solve the problem.

At one point, I thought that MSJet 3.51 under which my MDB file was created
has problems with unicode, but then how it comes it works OK with D6?
Method mentioned below to retrieve text as variant using .value property of
TField object - didn't work in my case.

I'm wondering if anybody else had the same problem with unicode data
retrieval/storage using MDB file with D7?
Are there any "hooks" I should be aware of?

Thanks.

BM.