Retour
-
Titre
Issue with running a cross-query when the data contains unicode characters (accents) -
Description
Issue with running a cross-query (Oracle DB) when the data contains Unicode characters. The below error occurs:
ORA-01406: fetched column value was truncated.
This may also cause an issue when publishing the result set from that cross-query and refreshing the snapshot.
Unicode characters include French accents such as é, è, ê, à etc.
Rows which are under the CHAR datatype are affected. -
Cause
This issue is caused by a product defect where Unicode characters are not supported in this specific scenario. -
Résolution
WORKAROUND
Use CAST in the cross-query to workaround the problem. Example:
Original:SELECT EMPNOFROM `oracle_connection`.SCOTT.EMPLOYEE;
Workaround:
SELECT cast (B.EMPNO as varchar2(120))FROM `oracle_connection`.SCOTT.EMPLOYEE B;
STATUS
Awaiting on a fix in a future version of Toad Data Point/Toad Intelligence Central. -
Identifiant du défaut
QAT-11163;TIC-8064