Article View: borland.public.cppbuilder.database.ado
Article #1715Re: ADO + unicode
From: Viatcheslav V. Vassiliev
Date: Thu, 15 Apr 2004 16:12
Date: Thu, 15 Apr 2004 16:12
77 lines
3729 bytes
3729 bytes
ADO Express converts Memo into AnsiString. You may use ADO recordset object:
ADOTable1->Recordset->Fields->Item[WideString("Definition")]->Value;
This will return OleVariant that should have type varOleStr or varNull.
//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)
"Christoffer Christoffersen" <christoffer.christoffersen@lxg.com>
�������/�������� � �������� ���������:
news:407ea8cb@newsgroups.borland.com...
> The field I am trying to read is a "Memofield", and that does not work at
> all cyrillic characters show up like questionmarks.
> Shall I convert the string I read or?
> //C
>
> "Viatcheslav V. Vassiliev" <support@oledbdirect.com> skrev i meddelandet
> news:407e98f6$1@newsgroups.borland.com...
> > > TntMemo1->Lines->Text =
> > > ADOTable1->FieldByName(WideString("Definition"))->AsString;
> >
> > AsWideString may solve problem. Be sure that fields is TWideStringField.
> > FieldByName(WideString("Definition")) will anyway use AnsiString since
it
> > accepts only it but not WideString as parameter.
> >
> > //------------------------------------------
> > Regards,
> > Vassiliev V. V.
> > http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
> > ADO.Net
> > http://www.oledbdirect.com - The fastest way to access MS SQL Server,
> > MS Jet (Access) and Interbase (through OLEDB)
> >
> > "Christoffer Christoffersen" <christoffer.christoffersen@lxg.com>
> > �������/�������� � �������� ���������:
> > news:407e9028@newsgroups.borland.com...
> > > The component I use supports cyrillic characters and when I load it
from
> a
> > > textfile it works ok, but the problem seems to be
> > > reading from MS-Access using the ADO-components. To be more clear on
my
> > > problem comes an example of my code...
> > >
> > > TntMemo1->Lines->Text =
> > > ADOTable1->FieldByName(WideString("Definition"))->AsString;
> > >
> > > Could someone guide me a bit on this one, thanks
> > > C
> > >
> > >
> > >
> > > "Christoffer Christoffersen" <christoffer.christoffersen@lxg.com>
skrev
> i
> > > meddelandet news:407e747d$1@newsgroups.borland.com...
> > > > Hi!
> > > > I am really stuck with this problem. How can I read unicode
characters
> > > > (cyrillic characers) that are stored in a MS-Access-table ?
> > > >
> > > > Thanks!
> > > >
> > > >
> > >
> > >
> >
> >
>
>
Technical Details
Message-ID:
<407eb46f@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!news.glorb.com!newsfeed.mesh.ad.jp!newsfeed.media.kyoto-u.ac.jp!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailReferences:
<407e747d$1@newsgroups.borland.com> <407e9028@newsgroups.borland.com> <407e98f6$1@newsgroups.borland.com> <407ea8cb@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: 10698b,c891a85e9b231b29 X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2004-04-15 09:29:39 PST From: "Viatcheslav V. Vassiliev" <support@oledbdirect.com> Newsgroups: borland.public.cppbuilder.database.ado References: <407e747d$1@newsgroups.borland.com> <407e9028@newsgroups.borland.com> <407e98f6$1@newsgroups.borland.com> <407ea8cb@newsgroups.borland.com> Subject: Re: ADO + unicode Date: Thu, 15 Apr 2004 20:12:33 +0400 Lines: 79 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 NNTP-Posting-Host: 213.234.218.42 Message-ID: <407eb46f@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1082045551 213.234.218.42 (15 Apr 2004 09:12:31 -0700) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!news.glorb.com!newsfeed.mesh.ad.jp!newsfeed.media.kyoto-u.ac.jp!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail