how to configure Access to Link to a UTF-8 database?

  • Thread starter Thread starter WPenfold
  • Start date Start date
W

WPenfold

Hi, How can I configure Access to link to a UTF-8 database and see the data?
I can link to tables OK, and display the data as long as there are no multi
byte characters. Any row containing any data with multi byte UTF-8
characters however, shows '#deleted' as the value of every column.
 
I'm connecting to an Oracle database using an Oracle ODBC driver. I can
connect and see the UTF-8 data in MS Access fine...as long as it doesn't
contain any multibyte characters. As soon as it hits a row with multibyte
characters like à then I can't see the data. I think the reason I'm getting
#Deleted is because the column with the multibyte characters is part of the
key. I made another table that just has some examples of multibyte
characters, but they just show up blank in Access.
 
Back
Top