Page 1 of 1

Options.Charset property of TOraSession

Posted: Thu 15 Mar 2007 13:47
by Davide Drago
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

Posted: Thu 15 Mar 2007 16:21
by Plash
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.