ODBC shows #Deleted for records in linked table when special characters like "Ü" in primary key
When connecting to an Oracle JD Edwards database (oracle database 12.1.0.1) with MsAccess 2016 using Oracle ODBC windows X64 instant client 12.2.0.1.0-2 I am not able to view records when there are special characters used like "Ö" or "Ä" in a string field when that field is part of the primary key of the table. For example use table F4108.IOLOTN (but is effective for all tables)
With the same settings (MS Access, ODBC etc.) I am however able to insert data with the same special characters to that table where a string field is part of the primary key of a table and I see with the JDE application the data correct and also with SQL developer or UTB.