Article View: borland.public.cppbuilder.database.ado
Article #2386Unicode problem...
From: M. Noroozi Eghbali
Date: Sat, 05 Jul 2003 17:18
Date: Sat, 05 Jul 2003 17:18
28 lines
1996 bytes
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-mailShow 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