Article View: borland.public.cppbuilder.database.ado
Article #1717Re: ADO + unicode
From: Christoffer Christoffersen
Date: Fri, 16 Apr 2004 05:49
Date: Fri, 16 Apr 2004 05:49
89 lines
4097 bytes
4097 bytes
Thanks, Viatcheslav!
It works great!
regards Christoffer
"Viatcheslav V. Vassiliev" <support@oledbdirect.com> skrev i meddelandet
news:407eb46f@newsgroups.borland.com...
> 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:
<407f73f7$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!news.glorb.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<407e747d$1@newsgroups.borland.com> <407e9028@newsgroups.borland.com> <407e98f6$1@newsgroups.borland.com> <407ea8cb@newsgroups.borland.com> <407eb46f@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 23:09:27 PST From: "Christoffer Christoffersen" <christoffer.christoffersen@lxg.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> <407eb46f@newsgroups.borland.com> Subject: Re: ADO + unicode Date: Fri, 16 Apr 2004 07:49:44 +0200 Lines: 91 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.88.240.2 Message-ID: <407f73f7$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1082094583 213.88.240.2 (15 Apr 2004 22:49:43 -0700) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!news.glorb.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail