Question Read CSV file into Oracle db

[pvds]

Hi guys,

Looks simple but i can't solve it at the moment, maybe you guys can help me out:

- Reading CSV file with vb.net code
- Place some fields of CSV in an oracle database

Some data have special characters for example the word Financiën (dutch).
When I read the CSV file the data looks correct but when i look in the oracle database
the word Financiën has changed into Financi?n...

it only happens for the special character ë .. why the ? .... ? and what will be the resolution

Regards, Pvds

 

[pvds]

Problem solved...

Changed special char into other char just before insert/updating record

Gr. P.

 

[cjard]

Sounds like you havent set a suitable characterset either in your oracle db, or in the driver connection string (Unicode=??? parameter?)