Devart Forums

Hello,

We are upgrading the Oracle database that our Delphi applications connect to through dbExpress for Oracle. WE are going from 7.3.4 to 11g (NLS_CHARACTERSET = UTF8). We are presently using version 4.90.0.25 of dbexpoda40.dll and the driver parameter we have been using for ServerCharSet=WE8ISO8859P1.

1. Do you advise updating our dbexpoda40.dll to the latest version for the upgrade to 11g? Any performance issues if we don't?

2. What ServerCharSet parameter do you advise using for the 11g - UTF8 database? We have been using WE8ISO8859P1 for 7.3.4.

Can you recommend any knowledge base documentation regarding this ServerCharSet setting and specifically it's effect on using our application with other regional settings such as Japanese? Does this setting have to correspond to the server character set or to the Windows client code page? Additionally there are settings for "unicodeenvironment" and "useunicode" We are actually unsure on all of these.

Thank you very much for your assistance,
Michael Malinowski
Production Resource Group

1) We are always working on performance improvement, so the performance in the new version is higher than in the previous one.
2) If you use a UTF8 database, you should specify the ServerCharSet that is specified in the parameter NLS_CHARACTERSET (SELECT * FROM V$NLS_PARAMETERS)
3) You should change the driver charset depending on the server charset. These parameters are described in the documentation (Readme.html )