Issue with running a cross-query when the data contains unicode characters (accents) (4324250)

Issue with running a cross-query when the data contains unicode characters (accents)

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.

This issue is caused by a product defect where Unicode characters are not supported in this specific scenario.

WORKAROUND
Use CAST in the cross-query to workaround the problem. Example:

Original:


STATUS
Awaiting on a fix in a future version of Toad Data Point/Toad Intelligence Central.

QAT-11163;TIC-8064