Write V_WSTRING Data in ORACLE DB

[Virender]

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.

[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!

[dindrani]

I am having the same issue.  When I use V_WString, I can see the non-English characters and Oracle has only the first character when I output this to an Oracle table.  However, when I change to V_String, I get ? in place of the foreign characters.  Please help.

Thank you

[grazitti_sapna]

Hi @Virender,

I guess it makes sense, V_WString is basically "double-wide" but the connection to Oracle is unaware, then in Oracle instead of getting...

xyz

... it sees ...

x0y0z0

(every-other character is literally a hexadecimal zero and Oracle regards that hex zero as the end of the string, all you ever get is the first character. So the issue makes sense

All you can do is make use of the Select tool and convert the datatype to v_string, that will solve your issue.

I hope it helps.

[dindrani]

I had tried that and unfortunately it does not.  It makes it worse.  It only takes the first character of the string and saves it in Oracle.  In this example, "T" my string starts with "This..." and ends with foreign characters.

[Virender]

Hi @grazitti_sapna 

Thanks for your response.

I have already tried to change the data type to v_string. But its not helping me. Conversion is discarding the special characters.

Best Regards,

Virender

[Virender · Accepted solution]

Hi @dindrani 

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

Best Regards,

Virender

[dindrani]

Thank you very much.  Yes, that did the trick.

Appreciate your help.

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