Page 1 of 1

execute SQL is not accurately sometimes when Set TUniConnect

Posted: Fri 05 Feb 2010 06:02
by daizhicun
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;

Posted: Mon 08 Feb 2010 08:23
by Plash
We have fixed this problem. The fix will be included in the next build of UniDAC.

Posted: Tue 17 Aug 2010 07:35
by daizhicun
Image

Posted: Wed 18 Aug 2010 07:01
by daizhicun
when will it be fixed?