[fdo-users] Different filter behaviour with King.Oracle

Gavin Cramer gavin.cramer at autodesk.com
Tue Sep 23 09:36:41 EDT 2008

Does the "LIKE" operator work if no percent '%' is added to the matching string?  Perhaps there is some difference in how the LIKE and = operators handle certain character sets on Oracle.


-----Original Message-----
From: fdo-users-bounces at lists.osgeo.org [mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of Andreas Morf
Sent: Tuesday, September 23, 2008 7:55 AM
To: fdo-users at lists.osgeo.org
Subject: [fdo-users] Different filter behaviour with King.Oracle

Hi all,
when applying the following filter to a SDF layer the symbolization is
working as expected: <Filter>STATUS = 'rechtskräftig'</Filter>

after importing the same data to oracle, the same same AreaRule results in
no data shown... changing the filter to <Filter>STATUS LIKE
'rechtskräftig%'</Filter> everything is shown again.

Should this be considered as a bug or is this an expected behavior?

Andreas Morf

fdo-users mailing list
fdo-users at lists.osgeo.org

More information about the fdo-users mailing list