🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #2386

Unicode problem...

#2386
From: M. Noroozi Eghbali
Date: Sat, 05 Jul 2003 17:18
28 lines
1996 bytes
Hi,

I saved a Unicode string to a MS-Access file but I could not retrieve it
correctly. would you please tell me what is wrong in these few commands:

//--------------------------------------------------------------------------
----------
//(TntEdit1 and TntEdit2 are Unicode components)
ADOCommand1->CommandText = "INSERT INTO Thesaurus (LineNum, USE) VALUES
(1000031, :USE)"; //Integer, Memo
ADOCommand1->Parameters->ParamByName("USE")->Value = TntEdit1->Text; // a
Unicode string - English + Russian
ADOCommand1->Execute();

ADOCommand1->CommandText = L"SELECT * FROM Thesaurus WHERE LineNum =
1000031";
ADODataSet1->Recordset = ADOCommand1->Execute();
TntEdit2->Text = ADODataSet1->FieldByName("USE")->Value; //The Russian part
is shown like ??????????
//--------------------------------------------------------------------------
-----------


When I see the record by using MS-Access, the USE field contains both
English and Russian languages correctly. What should I do?

Thank you,
Mehrdad
Technical Details
Message-ID: <3f07078e@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-06!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!colt.net!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,991da78fb4c9f597,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-07-05 10:39:24 PST
From: "M. Noroozi Eghbali" <galaxy@irandoc.ac.ir>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Unicode problem...
Date: Sat, 5 Jul 2003 21:48:22 +0430
Lines: 31
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2720.3000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2727.1300
NNTP-Posting-Host: 213.176.21.5
Message-ID: <3f07078e@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1057425294 213.176.21.5 (5 Jul 2003 10:14:54 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-06!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!colt.net!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail