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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Greg J - 07 Jul 2008 02:37 GMT

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.

Reply to this Message

Greg J - 07 Jul 2008 03:09 GMT

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).

Reply to this Message

VB Forum / Database Access / July 2008

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