clientDataSet中文过滤问题

[qingxin76]

我用ClientdataSet过滤，数据库是oracle
只对中文过滤没有效果
那位有什么好的解决办法吗？谢谢啦

[eFainter]

楼主，能说的详细点吗？

[qingxin76]

我的clientdataset是adoquery得到数据转换过来的
想对clientdataset进行过滤
if lstwhere <>'' then
begin
Datasource.DataSet.Filter := lstwhere;
Datasource.DataSet.Filtered := True;

end;
过滤后，查看datasource.dataset.recordcount=0
lstwhere='OHLINENAME=''安老二'''
我看了clientdataset的xml是如下：
<?xml version="1.0" standalone="yes" ?>
- <DATAPACKET Version="2.0">
- <METADATA>
- <FIELDS>
<FIELD attrname="OHLINENAME" fieldtype="string.uni" WIDTH="100" />
<FIELD attrname="OWNERUNIT" fieldtype="string.uni" WIDTH="60" />
<FIELD attrname="RUNNINGUNIT" fieldtype="string.uni" WIDTH="100" />
<FIELD attrname="RUNNINGVOL" fieldtype="string.uni" WIDTH="20" />
<FIELD attrname="GTBH" fieldtype="string.uni" WIDTH="40" />
<FIELD attrname="BANZUBH" fieldtype="string.uni" WIDTH="100" />
<FIELD attrname="FLAWTYPE" fieldtype="string.uni" WIDTH="40" />
<FIELD attrname="XXXZBH" fieldtype="string.uni" WIDTH="100" />
<FIELD attrname="FLAWPART" fieldtype="string.uni" WIDTH="100" />
<FIELD attrname="FLAWCONTENT" fieldtype="string.uni" WIDTH="100" />
<FIELD attrname="FLAWPHENOMENON" fieldtype="string.uni" WIDTH="1000" />
<FIELD attrname="XXDATE" fieldtype="dateTime" />
<FIELD attrname="FLAWPROPERTY" fieldtype="string.uni" WIDTH="40" />
<FIELD attrname="ISFAULT" fieldtype="string.uni" WIDTH="20" />
<FIELD attrname="CLGG" fieldtype="string.uni" WIDTH="1000" />
<FIELD attrname="TREATDEPT" fieldtype="string.uni" WIDTH="100" />
<FIELD attrname="TREATDATE" fieldtype="dateTime" />
<FIELD attrname="TREATLEADER" fieldtype="string.uni" WIDTH="100" />
<FIELD attrname="EXAMINER" fieldtype="string.uni" WIDTH="100" />
<FIELD attrname="XQBJ" fieldtype="string.uni" WIDTH="4" />
<FIELD attrname="JX_FH" fieldtype="string.uni" WIDTH="1000" />
<FIELD attrname="PROCESSDESC" fieldtype="string.uni" WIDTH="1000" />
<FIELD attrname="FLAWSTATUS1" fieldtype="string.uni" WIDTH="40" />
<FIELD attrname="RECIPIENT" fieldtype="string.uni" WIDTH="100" />
<FIELD attrname="ACCEPTDESC" fieldtype="string.uni" WIDTH="1000" />
<FIELD attrname="REPORTER" fieldtype="string.uni" WIDTH="100" />
<FIELD attrname="REPORTDATE" fieldtype="dateTime" />
<FIELD attrname="FLAWID" fieldtype="string.uni" WIDTH="80" />
<FIELD attrname="DUTYUNIT" fieldtype="string.uni" WIDTH="60" />
<FIELD attrname="DUTYDEPT" fieldtype="string.uni" WIDTH="60" />
</FIELDS>
<PARAMS />
</METADATA>