special characters being replaced while writing data from csv to oracle table

[ravitejapaideti]

Field is V_String- unable to retain special character (e.g. John, DoeNo├½lle Isabelle), it is replaced with question mark (?). If I select the type as V-WString, it is omitting the special character and writing the first character into table. How to handle such special characters?

[apathetichell]

is it the reading which is replacing the special characters - or the writing? for you .csv read it in as a different code... UTF-8?

[danilang]

Hi @ravitejapaideti 

This could be related to your oracle database not supporting the extended characters.  Check here to find out the code page/ character set that your data base supports.  As @apathetichell mentioned it could also an issue with the client that you're using to look at the oracle data.  Check to see it supports the proper code page as well.

Dan

[ravitejapaideti]

It is happening while writing the data and yes, UTF-8

[ravitejapaideti]

I'll check this article. Thanks!