TOraSession.Pooling work not correct

[Slava]

Hello.

I used latest ODAC for for RAD Studio XE7 v9.5.18. ()
Oracle settings:
Version 9.2.0.6.
NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1

My settings ODAC OraSession1:
OraSession1.Direct := True;
OraSession1.Charset := 'WE8ISO8859P1';

Everything works well, but at OraSession1.Pooling=True addition, OraSession1.PoolingOptions.MaxPoolSize=10 and OraSession1.PoolingOptions.MinPoolSize=2 in a database writing not the correct coding of symbols (possibly UTF-8).
But I need WE8ISO8859P1.
Please help.

[AlexP]

Hello,

Please execute the following queries and send me their results:

Code: Select all

SELECT USERENV ('language') from dual; 

SELECT * FROM V$NLS_PARAMETERS;

[Slava]

SELECT USERENV ('language') from dual;
AMERICAN_AMERICA.WE8ISO8859P1

SELECT * FROM V$NLS_PARAMETERS;
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD.MM.YYYY HH24:MI:SS
NLS_DATE_LANGUAGE AMERICAN
NLS_CHARACTERSET WE8ISO8859P1
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE

[AlexP]

Thank you. In addition, please specify the type of the field, where you insert data, and the data inserted incorrectly.

[Slava]

OraSql1.ParamByName('Surname').AsString := 'ИВАНОВ';
OraSql1.ParamByName('Firstname').AsString := 'ИВАН';
OraSql1.ParamByName('Fathname').AsString := 'ИВАНОВИЧ';

[AlexP]

please specify the type of the fields (varchar2 or Nvarchar2)?

[Slava]

varchar2(30)

[AlexP]

Thank you for, we have reproduced the described problem and will investigate the reason for such behavior.

[AlexP]

We have already fixed the problem. The fix will be included in the next version.

[Slava]

Thanks for the good news.
When there will be the following release?

[AlexP]

The new version including this fix will be released the next week.