Article View: borland.public.cppbuilder.database.ado
Article #3332Re: Storing UNICODE in Jet 4.0 memo fields using ADO Xpress
From: Vassiliev V.V.
Date: Sun, 22 Sep 2002 09:42
Date: Sun, 22 Sep 2002 09:42
37 lines
2216 bytes
2216 bytes
You can try use Recordset object directly and set Recordset.Fields['MemoField'].Value = OleString. In OLEDB you just bind the field as DBTYPE_BSTR. Regards, Viatcheslav V. Vassiliev http://www.oledbdirect.com The fastest way to work with MS SQL Server and MS Jet databases. "Bob Leschhorn" <blesch@arksoft.com> �������/�������� � �������� ���������: news:3d8c8c66$1@newsgroups.borland.com... > Hi, > > I have been trying to store UNICODE text (UCS-2) into memo fields but have > only had success by using a BLOBStream to write the Unicode text to the memo > field. If I do this, the text is not correctly visible when the records are > viewed with Access 2000. I can retrieve the Unicode text quite happily from > the database. > > If I go into Access and type directly into the memo fields in the tables in > Greek, Russian whatever, the text is stored a UCS-2 and is correct when seen > in a system that is I18-ized. > > Can anyone please give me a pointer or two. I have tried everything - > literally. > > Thanks > > > >
Technical Details
Message-ID:
<3d8d993e@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-04!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<3d8c8c66$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: 10698b,91114a94e17d96f9 X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2002-09-22 03:42:01 PST From: "Vassiliev V.V." <news@vassilievvv.mtu-net.ru> Newsgroups: borland.public.cppbuilder.database.ado References: <3d8c8c66$1@newsgroups.borland.com> Subject: Re: Storing UNICODE in Jet 4.0 memo fields using ADO Xpress Date: Sun, 22 Sep 2002 13:42:54 +0400 Lines: 39 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 NNTP-Posting-Host: 62.118.136.193 Message-ID: <3d8d993e@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1032689982 62.118.136.193 (22 Sep 2002 03:19:42 -0700) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-04!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail