Where do my accents go?

jphendriks · Post by **jphendriks** » Wed 19 Oct 2005 14:17

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.

Alex · Post by **Alex** » Thu 20 Oct 2005 08:57

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.