"ustring[max=50]" to result type "string[max=

[deepa_shenoy]

Hi,

I am getting the following error:

ODBC_PR_CUSTOMER: When checking operator: When binding output interface field "PARTY_NAME" to field "PARTY_NAME": Implicit conversion from source type "ustring[max=50]" to result type "string[max=255]": Converting ustring to string using codepage UTF-8.

The source and target columns are VARCHAR but of different lengths.

I dont understand why it is saying USTRING to string.

How to resolve this issue?

Thanks in advance.

Deepa

[nani0907]

hello,

use the data type as Nvarchar.

[AmeyJoshi14]

Hi,

I am getting the following error:

ODBC_PR_CUSTOMER: When checking operator: When binding output interface field "PARTY_NAME" to field "PARTY_NAME": Implicit conversion from source type "ustring[max=50]" to result type "string[max=255]": Converting ustring to string using codepage UTF-8.

The source and target columns are VARCHAR but of different lengths.

I dont understand why it is saying USTRING to string.

How to resolve this issue?

Thanks in advance.

Deepa

Hi,

I guess ... not sure ... in source metadata you are using "PARTY_NAME" column as Unicode --Varchar2(50).

Just remove the unicode and run the job ...

Thanks!!

[deepa_shenoy]

My Database is Oracle. The column is declared as VARCHAR2(50). But while importing metadata I have not declared as Unicode.

[nani0907]

have you tried by declaring the data type as NVarchar.i guess this error is due to special characters in that particular column value.

[deepa_shenoy]

In job 1, I am loading Table 1 to Table 2. In Table 2 all columns have been declared VARCHAR and all data is loaded successfully.

In job 2, I am loading Table 3 from the same Table 2. Both have all columns declared as VARCHAR. In this job 2 its throwing this error of implicit conversion from ustring to string.

If there were Unicode or special characters, it should have thrown the same warning for Job 1 too right?

[ray.wurlod]

Take a slow, systematic walkthrough of the job. Look closely at all the Columns grids in all the stages. Look for instances of Unicode.