ODAC version:6.8.0.46
oracle: oracle 10.2.0.4.0
oracle chartset:ZHS16GBK
OS: windows xp simple chinese sp3
create table YHK
(
ID NUMBER(38) not null,
NAME VARCHAR2(20),
PASSWORD VARCHAR2(20),
EMAIL VARCHAR2(50),
HOMEPAGE VARCHAR2(100),
ADR VARCHAR2(200),
INDATE DATE,
BZ VARCHAR2(1),
ADMIN VARCHAR2(1),
NOTE VARCHAR2(1000),
LASTTIME DATE
)
with cx do
begin
sql.Clear;
sql.Add('select * from yhk where name=:bh');
params[0].AsString:='xa';
open;
showmessage(fields[0].AsString);
end;
in databse I have a record and name='xa',
but when run this code. it return nothing.
this code in delphi 2007, it works fine.