execute SQL is not accurately sometimes when Set TUniConnect

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
daizhicun
Posts: 109
Joined: Thu 21 Jan 2010 11:49

execute SQL is not accurately sometimes when Set TUniConnect

Post by daizhicun » Fri 05 Feb 2010 06:02

when Set TUniConnection :'Oracle.UseUnicode=True'
and 'Oracle.Direct=True'

I find that the Sql can not be parse accurately sometimes;

for example:

when i execute:

SELECT
MDL_ID,--1模块ID
MDL_CD--2模块I
FROM
T_SYS_MDL

the message is:ORA-01742: comment not terminated properly


But When i set "MDL_CD--2模块I " instead of "MDL_CD--2模块I"
(only add a blank space ) ,
It can be execute accurately!

so I can not user 'Oracle.UseUnicode=True'!

But if i not use 'Oracle.UseUnicode=True' ,
then In Direect Mode , nvarchar2 field can not Show chinese completely.

in oreder to know it deeply.
I test it in TOAD and KEEP TOOL;

i find that TOAD is Ok in direct Mode;
but KEEP TOOL has error too.

I think KEEP TOOL perhaps use UNIDAC or ODAC;

Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Mon 08 Feb 2010 08:23

We have fixed this problem. The fix will be included in the next build of UniDAC.

daizhicun
Posts: 109
Joined: Thu 21 Jan 2010 11:49

Post by daizhicun » Tue 17 Aug 2010 07:35

Image

daizhicun
Posts: 109
Joined: Thu 21 Jan 2010 11:49

Post by daizhicun » Wed 18 Aug 2010 07:01

when will it be fixed?

Post Reply