Problem with special charcter and Oracle.direct

invent · Post by **invent** » Tue 15 Jun 2010 17:43

Hi,

I have a problem with special characters. In a small table "DBUser" I administrate user and there passwords. 2 Fields: "DBUserId" and "DBUserPwd". The password is encrypted.

SQL: select DBUserPwd from DBUser where DBUserId = '123'

1. Attempt with Oracle-Client, the result is:

N€Áë

2. Attempt with specific option Oracle.Direct=True, the result is:

N¿Áë

I tried this with Delphi 7, Oracle 8, InterBase 2007 and UniDac Prof 2.70.0.9.

How can I get the same results in both attemps? Is this an language
problem?

Thanks in advance for any information.

Kind regards,
Gerd Brinkmann
invent GmbH

invent · Post by **invent** » Tue 15 Jun 2010 18:16

Hi,

I solved this problem with the specific option Oracle.Charset.

I thought that the Oracle.Direct mode is very simply to use. I just want to set the specific option and everything is good ... until the next problem.

Kind regards,
Gerd Brinkmann
invent GmbH

bork · Post by **bork** » Wed 16 Jun 2010 13:55

Hello

It is good to see that this problem has been solved. If any other questions come up, please contact me.