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

[Gavin Cramer]

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.

Gavin


-----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
http://lists.osgeo.org/mailman/listinfo/fdo-users