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

Question

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?

ravitejapaideti · Answer

I'll check this article. Thanks!

ravitejapaideti · Answer

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

danilang · Answer

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