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

Converse agora com nosso suporte

Voltar

Feedback enviado

Este artigo resolveu um problema para você?

Selecione a classificação

Título

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

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.
Causa

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

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

Original:

SELECT EMPNO
FROM `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.
ID do defeito

QAT-11163;TIC-8064

Feedback enviado

Este artigo resolveu um problema para você?

Selecione a classificação

Conteúdo recomendado

Título