Oracle 12c Russian Characters

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Peter62
Posts: 4
Joined: Fri 06 Oct 2017 12:45

Oracle 12c Russian Characters

Post by Peter62 » Mon 23 Oct 2017 12:22

Hello support team,

we are using
- Oracle 12c in DirectMode, UseUnicode=True, UnicodeEnvironment=True
- Delphi Seattle
- UniDAC 7.1.4

When we select rows (not inserted by UniDAC) wich contains russian characters, the data looks fine.
If we insert or update data using UniDAC, there are only '?????' für the russian characters in the database.

What can we do?

Thanks in advance,

Peter

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Oracle 12c Russian Characters

Post by MaximG » Tue 24 Oct 2017 10:01

To investigate the issue, please explain:

- what NLS parameters the used Oracle 12c has (in order for you to get them, use the following query : select * from v$nls_parameters )
- what type the fields, the values of which after inserting data consist of ???????? symbols, have
- provide the sample of inserting data in such fields using UniDAC

You can send your explanation via the e-support form ( https://www.devart.com the "Support"\"Request Support" menu)

Peter62
Posts: 4
Joined: Fri 06 Oct 2017 12:45

Re: Oracle 12c Russian Characters

Post by Peter62 » Tue 24 Oct 2017 14:20

Hello,

sorry, that was my mistake. The UnicodeEnvironment was not set.

All works fine!

Thanks,
Peter

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Oracle 12c Russian Characters

Post by MaximG » Wed 25 Oct 2017 05:51

We are glad that you found a necessary solution. Please don't hesitate to contact us with questions concerning UniDAC usage.

Post Reply