Devart Forums

Hi, I'm trying to save words with accents, like á or ß, through the Odac driver into the database. It is not saved correctly. The word "weiß' is saved as 'wei?', and 'café' is saved as 'cafe'.

If I try to do so using sqlplus the words are saved correctly.
INSERT INTO mytable VALUES ('weiß') will insert weiß correctly.

What can I do to make this work correctly through ODAC (and ODBC) as well?

Thanks,
JP.

There are two things that you can do. The first is to setup correct charset using TOraSession.Options.Charset, the second is to set TOraSession.UseUnicode property.
Please pay attention to "Working with Unicode character data" topic of ODAC help.