Devart Forums

Hello,

We use UNIDAC 2.00.0.3 on a ORACLE 10g database, with CodeGear Delphi RAD Studio 2007

We notice some differences when running in direct mode (without an oracle client)

1. different sort-order
direct mode : strings starting with 'S (quote + S) come first in order

'S
A
B
...
S
T

via oracle client : strings starting with 'S (quote + S) come just before strings starting with S
A
B
...
'S
S
T

2. problems with date & date/time in update SQL's
UniQuery.ParamByName('LAST_CHANGED').AsDateTime:=now;
via oracle client : no problems
direct mode : error ORA-00932 inconsistent datatype, expected DATE got number

Registry entry for ORACLE client :
NLS_LANG = DUTCH_THE NETHERLANDS.WE8MSWIN1252

specific options set in TUniConnection :
charset WE8MSWIN1252
dateformat DD/MM/YYYY
datelanguage DUTCH

Any idea what the reason is ?

1. Sort order differs because NLS_LANG value is not used in the Direct mode. You can solve the problem in two ways:
a) Set NLS_LANGUAGE to DUTCH in the initialization parameter file for the Oracle instance.
b) Execute the following query:
ALTER SESSION SET NLS_LANGUAGE=DUTCH
after connecting to the database.

2. We could not reproduce the problem with date. Please send to unidac*devart*com a complete small sample that demonstrates the problem, including the script for creating database objects.