Storing Unicode in Access 2000 / JET 4.0 table

• Previous message: Otto Stolz: "Long S (was: How do I encode HTML documents in old languages ſuch as 17th century Swediſh in Unicode?)"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
• Mail actions: [ respond to this message ] [ mail a new topic ]

Hi,

I am trying to save Unicode text into an Access database (JET 4.0) by
using ADO (C++ Builder 5 + ADO Express) but it seems that the underlying
code converts the Unicode to codepage text and Access converts this back
to Unicode which plays havoc with Greek and Russian.

Tried using the SetData() method but this crashes.

So far, I have had success by saving the Unicode data as BLOB data into a
memo field but the data saved thus is illegible when you look at the table
in Access 2000 itself.

Access, however, seems to be able to do this. If you type either Greek or
Russian text into a record, it is preserved as Unicode in the underlying
JET 4.0 database.

I have looked everywhere and tried just about everything. The only
thing I haven't tried is raw ADO. Does anyone have any pointers on how
this may be achieved?

Thanks,

=========================================================================
Bob Leschhorn blesch@cix.compulink.co.uk
Ark Software
Gerrards Cross, Bucks
United Kingdom
=========================================================================

• Previous message: Otto Stolz: "Long S (was: How do I encode HTML documents in old languages ſuch as 17th century Swediſh in Unicode?)"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
• Mail actions: [ respond to this message ] [ mail a new topic ]

This archive was generated by hypermail 2.1.2 : Wed Jul 10 2002 - 03:14:03 EDT