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

Zac Spitzer zac.spitzer at gmail.com
Tue Sep 23 10:30:35 EDT 2008


does oracle being case sensitive play a role?

On Tue, Sep 23, 2008 at 11:45 PM, Andreas Morf <a.morf at fkl.ch> wrote:
> No, unfortunately, the LIKE operator without '%' (<Filter>STATUS LIKE
> 'rechtskräftig'</Filter> ) doesn't work either...
>
> In my opinion this seems to be a bug.
>
> Andreas
>
>> -----Original Message-----
>> From: fdo-users-bounces at lists.osgeo.org [mailto:fdo-users-
>> bounces at lists.osgeo.org] On Behalf Of Gavin Cramer
>> Sent: Tuesday, September 23, 2008 3:37 PM
>> To: FDO Users Mail List
>> Subject: RE: [fdo-users] Different filter behaviour with King.Oracle
>>
>> 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
>> _______________________________________________
>> fdo-users mailing list
>> fdo-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/fdo-users
>
> _______________________________________________
> fdo-users mailing list
> fdo-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-users
>



-- 
Zac Spitzer -
http://zacster.blogspot.com (My Blog)
+61 405 847 168


More information about the fdo-users mailing list