Problem with unicode Please help me soon

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
omidshf
Posts: 1
Joined: Sat 22 Jan 2005 05:38
Contact:

Problem with unicode Please help me soon

Post by omidshf » Tue 09 Aug 2005 05:17

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 .

Paul
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Post by Paul » Tue 09 Aug 2005 06:44

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.

Post Reply