Storing UNICODE in Jet 4.0 memo fields using ADO Xpress

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

Article #3330

Back to borland.public.cppbuilder.database.ado Previous Next

#3330

From: Bob Leschhorn
Date: Sat, 21 Sep 2002 15:12

16 lines
1662 bytes

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: <3d8c8c66$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-08!supernews.com!newsfeed.news2me.com!news.stealth.net!news.stealth.net!iad-peer.news.verio.net!news.verio.net!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,91114a94e17d96f9,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-09-21 08:32:03 PST
Reply-To: "Bob Leschhorn" <blesch@arksoft.com>
From: "Bob Leschhorn" <blesch@arksoft.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Storing UNICODE in Jet 4.0 memo fields using ADO Xpress
Date: Sat, 21 Sep 2002 16:12:40 +0100
Lines: 20
Organization: Ark Software
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.188.59.190
Message-ID: <3d8c8c66$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1032621158 62.188.59.190 (21 Sep 2002 08:12:38 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-08!supernews.com!newsfeed.news2me.com!news.stealth.net!news.stealth.net!iad-peer.news.verio.net!news.verio.net!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!newsgroups.borland.com!not-for-mail