Options.Charset property of TOraSession

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Davide Drago
Posts: 1
Joined: Thu 15 Mar 2007 10:02

Options.Charset property of TOraSession

Post by Davide Drago » Thu 15 Mar 2007 13:47

Hello,
I have a BDE application that i'm tried to convert to ODAC.
All the data saved in the database was saved through BDE with LANGDRIVER Paradox 'intl'.
The database is an Oracle 10.2.0 with NLS_LANG = ITALIAN_ITALY.WE8ISO8859P1.
If in a dos windows i typed "CHCP" the result is: Active code page: 850, that are the same of Paradox 'intl'.
I've tried to set the Options.Charset property of TOraSession, when it is disconnected, to WE8PC850 without any result, for example the "à" or "è" characters save with BDE are displayed "þ" in ODAC.
Have you any suggestion to fix this problem?

Thanks in advance,
Davide

Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Thu 15 Mar 2007 16:21

The Charset option of the TOraSession component should be set to WE8MSWIN1252. Alternatively, you can set the NLS_LANG key in the system registry to this value and set the Charset option to an empty string.

Post Reply