Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Unicode Compression value for Memo field always false reading Access 2000 db

0 views
Skip to first unread message

Greg J

unread,
Jul 6, 2008, 9:37:09 PM7/6/08
to
I am writing some code that will read an Access 2000 database
structure using ADOX and store the details in a set of tables. I have
it mostly done but I have noticed that when reading through the
properties of the columns, the Unicode compression property (Jet
OLEDB:Compressed UNICODE Strings) is always False for Memo fields
regardless of its actual value (text fields are correct).

If I manually set the value to True in the tables then create a new
database from that recordset, the correct Unicode Compression value is
created correctly.

Greg J

unread,
Jul 6, 2008, 10:09:52 PM7/6/08
to
Further info.

Interestingly...

If I change the memo field to a text field (with unicomp set to true),
save the table/field changes, then change the text field back to a
memo field and save the changes, my code reads the correct value for
Unicode of the Memo field.

So it would appear that if a field is created as a memo field and
unicomp property is set to true, it doesnt read correctly with ADOX.
If a field is set as a text field with unicomp set to true then
changed to a memo field, it will read correctly (true or false).

0 new messages