Problem with loading special language characters from CSV files

[#1]

Hello,

I would like to load a CSV file with Data Services into an Oracle database table.

The CSV file contains special language characters (Umlaute like ä, ö, ü) as the conten is German.

But the special characters are not properly loaded to the oracle table.

Does anyone know a solution for this - in my opinion - standard task?

Which coding must the csv file have, UTF-8 or ANSI?

Thanks for your help in advance!

Philipp

[Former Member]

Hello

Data Services will handle any character set, but it is up to the developer to set the right codepage and language.  File formats, and many datastores allow you to specify these locale settings.  I suspect you have might have something set to "default".

If I ever have an issue loading characters I set everything to UTF-8 of UTF-16.  Your Oracle database must also be configured to handle the characters too.  AL32UTF8 is the mother of all character sets.

Michael