842106 wrote:How do I ask a question on the forums?
I am currently facing a strange issue while loading a csv into oracle BE table.
The data is coming as TÃ©cnicas but I need to store it as Técnicas . I think there is some character set issue for which data is coming as in distorted manner .
I am using oracle 10G enterprise edition .
Any help is greatly appreciated.
842106 wrote:Since you mentioned loading a file, how file content is encoded matters. And depending on how file is loaded, the char set part of NLS_LANG should be set accordingly.
As I told by you I checked Unix locale settings as well as in oracle NLS_DATABASE_PARAMETERS.
Unix locale was set to UTF8 but as you have mentioned NLS_DATABASE_PARAMETERS was set to AL32UTF8 which is why the characters where were not converted.How exactly did you change what?
So after changing it to UTF8 and column as Nvarchar solved my issue .