Oracle 19c database.
I have a database link that connects to a Snowflake database. One of the views of data in Snowflake that we access through the link contains names with diacritic characters. We are having issues with the characters not appear correctly.
Some names look fine; others characters that appeared fine on some names will appear with sideways rectangles instead of the correct character. And in other cases, the sideways rectangle will appear at the beginning of the name followed by the correct first character of the name.
We are at a bit of a stalemate because the Snowflake team can see the data correctly and feels there is nothing that can be done on their side to correct the issue and the Oracle side of the house also feels there is nothing else that can be done.
--Both databases use UTF8 character set.
--The DBA has added the following config entries for the interface:
HS_LANGUAGE=AL32UTF8
HS_FDS_REMOTE_DB_CHARSET=UTF8
--Multiple tools have been used to connect from Oracle to Snowflake to rule out a config issue with the tool itself
--Queries have been run using multiple different character set conversion attempts to no avail
Is there anything else that can be done to troubleshoot this on the Oracle side?