delphi 2010+odac 6.90.0.51 params as chinese string error!

xalion · Post by **xalion** » Tue 15 Sep 2009 07:40

version:delphi 2010
os version: win xp chinese
oracle version: oracle 10.2.0.4
direct mode:True

cx.SQL.Clear;
cx.SQL.Add('select * from XTB ');
cx.SQL.Add('where BZ=:bz and sysbz=''T''');
cx.Params[0].AsString:='abc';
cx.open;
It works fine.
cx.SQL.Clear;
cx.SQL.Add('select * from XTB ');
cx.SQL.Add('where BZ=:bz and sysbz=''T''');
cx.Params[0].AsString:='年份';
cx.open;
It show error!

Plash · Post by **Plash** » Wed 16 Sep 2009 10:45

Please specify the character set of your database, and the error message that you have received.

xalion · Post by **xalion** » Wed 16 Sep 2009 14:32

character set :ZHS16GBK

error:ORA01460:unimplemented or unreasonble conversion requested!

Plash · Post by **Plash** » Thu 17 Sep 2009 09:11

We have reproduced this problem, and we are working on it. You will be notified when we fix the problem.

Matt · Post by **Matt** » Tue 13 Oct 2009 10:25

Hi

I am looking at upgrading my odac components to version 6.90.0.51 using Delphi 2006.

Could you please tell me if this problem would exist in my version of delphi as we do have quite a few chinese customers that this could affect.

Many Thanks

Matt

Plash · Post by **Plash** » Wed 14 Oct 2009 07:13

This problem is fixed in ODAC 6.90.0.51.

azabluda · Post by **azabluda** » Wed 14 Oct 2009 08:49

Hi Plash,

I'm keeping an eye on this ticket too, because we hit the same problem which DOES persist in 6.90.0.51 / C++Builder 2009. Did you mean some later build of 6.90.0.51 where "this problem is fixed"? I checked my registered user area today, but the bug is still there.

Thanks,
Alexander

Plash · Post by **Plash** » Thu 15 Oct 2009 09:10

This topic describes another problem (not related to OCIUnicode = True). Please see my reply to your e-mail regarding the problem with OCIUnicode.

xalion · Post by **xalion** » Fri 16 Oct 2009 01:04

with new 6.90.0.52. the1 bug is still there!!

xalion · Post by **xalion** » Wed 28 Oct 2009 01:39

when will you fix this bug?

Plash · Post by **Plash** » Thu 29 Oct 2009 07:54

We are planning to fix this problem in the next ODAC build.

Matt · Post by **Matt** » Thu 26 Nov 2009 13:21

Please can you confirm this problem is fixed in 6.90.0.53

Many Thanks

Matt

xalion · Post by **xalion** » Fri 27 Nov 2009 01:31

This bug is removed!