Write V_WSTRING Data in ORACLE DB

Hi All,

I have a straight forward workflow in which, I am reading data from a table having UTF characters and writing back into the same table.

WCHAR column data is properly read using "Force SQL WCHAR Support" from a oracle DB table.
While writing the same v_wstring data in same oracle table, column value got truncated below.

Input:

Output:

I am not able to write V_WSTRING data in oracle db table. Whenever I am writing it, data got truncated and First character is getting loaded in the table.

Datasets

Output

Database Connection

Accepted answers

Virender

Hi @dindrani

I have one work around. Just change the data type to NVARCHAR2 in oracle DB.

Best Regards,

Virender

All comments

TrevorS

Hello @Virender

Are you able to upload the workflow and some sample data in the same format as the files you are using?

This will help to troubleshoot whats happening better.
Thanks!

Trevor

Virender

Hello @TrevorS,

I have attached the sample workflow where, I am reading data from same table inserting into the same table.
I am getting below result. Also I have attached sample data.

Input data from same table:

Output data in same table or same schema table

Also here is the table schema.

this issue is occurring where I have UTF characters in the dataset.

Thanks for your Help!

test_workflow.yxzp

shakir_juolay

In addition to changing the data type to NVARCHAR2 in oracle DB, I also needed to change the data type to V_WString : Forced using the SELECT Tool, data type of V_WString did not work for me.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703