Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

MS Access and Oracle Database

housetiger77Nov 28 2018 — edited Dec 5 2018

I've created a MS Access 2016 front end application and i'm using Oracle 11g as the back end database. I'm using the 11.2 ODBC driver to link them and I'm having an issue with Access not displaying certain symbols. The symbol in question is the diameter symbol and to display it you have to type ALT + 0216. The Oracle table shows the symbol correctly, but when viewing it in Access it does not. There seems to be a disconnect in how Access translates the data from the Oracle db. I've tried changing some of the settings on the ODBC driver, but nothing has helped. The data_type for the column is VARCHAR2 (4000) and in Access that is equivalent to Long Text. Does anyone have any clue what the issue might be? Any help is appreciated!

Comments
Post Details
Added on Nov 28 2018
2 comments
1,324 views