Page 1 of 1

Problem with unicode Please help me soon

Posted: Tue 09 Aug 2005 05:17
by omidshf
Hi :
I am iranian programer .
I used Oracle 9.1 As DBMS in Win 2000 Advance Server , And I Program in Delphi 7 In win Xp
For Client and i use ODAC 5.10.0.5

I have 2 problems

1 - when I post in varchar2's field system returns me this error :
" can bind a long value only for insert into a long column "

2 - When I Select Varchar2'S Field With (Like) System Dont Return any row but this row exists in table .

Example : Select * From smx01 Where Name_Family like '%Var_Name%'

Note1 : Value of this Fields are Farsi .
Note2 : System Codepage : 1256 .

Posted: Tue 09 Aug 2005 06:44
by Paul
1. This problem is fixed in ODAC 5.55.0.21. If you have a problem with last ODAC build send us please small demo project to demonstrate the problem and include script to create server objects.
2. Try to execute your query in SQL Plus.