<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
h1
{margin-top:12.0pt;
margin-right:0cm;
margin-bottom:3.0pt;
margin-left:0cm;
text-indent:0cm;
page-break-after:avoid;
mso-list:l2 level1 lfo23;
font-size:16.0pt;
font-family:Arial;}
h2
{margin-top:12.0pt;
margin-right:0cm;
margin-bottom:3.0pt;
margin-left:0cm;
text-indent:0cm;
page-break-after:avoid;
mso-list:l2 level2 lfo23;
punctuation-wrap:simple;
text-autospace:none;
font-size:14.0pt;
font-family:Arial;}
h3
{margin-top:12.0pt;
margin-right:0cm;
margin-bottom:3.0pt;
margin-left:0cm;
text-indent:0cm;
page-break-after:avoid;
mso-list:l2 level3 lfo23;
punctuation-wrap:simple;
text-autospace:none;
font-size:13.0pt;
font-family:Arial;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EpostStil18
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:163790300;
mso-list-template-ids:67698719;
mso-list-style-name:"1 \/ 1\.1 \/ 1\.1\.1";}
@list l0:level1
{mso-level-tab-stop:18.0pt;
mso-level-number-position:left;
margin-left:18.0pt;
text-indent:-18.0pt;}
@list l0:level2
{mso-level-text:"%1\.%2\.";
mso-level-tab-stop:54.0pt;
mso-level-number-position:left;
margin-left:21.6pt;
text-indent:-21.6pt;}
@list l0:level3
{mso-level-text:"%1\.%2\.%3\.";
mso-level-tab-stop:90.0pt;
mso-level-number-position:left;
margin-left:25.2pt;
text-indent:-25.2pt;}
@list l0:level4
{mso-level-text:"%1\.%2\.%3\.%4\.";
mso-level-tab-stop:108.0pt;
mso-level-number-position:left;
margin-left:32.4pt;
text-indent:-32.4pt;}
@list l0:level5
{mso-level-text:"%1\.%2\.%3\.%4\.%5\.";
mso-level-tab-stop:144.0pt;
mso-level-number-position:left;
margin-left:39.6pt;
text-indent:-39.6pt;}
@list l0:level6
{mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6\.";
mso-level-tab-stop:180.0pt;
mso-level-number-position:left;
margin-left:46.8pt;
text-indent:-46.8pt;}
@list l0:level7
{mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6\.%7\.";
mso-level-tab-stop:216.0pt;
mso-level-number-position:left;
margin-left:54.0pt;
text-indent:-54.0pt;}
@list l0:level8
{mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6\.%7\.%8\.";
mso-level-tab-stop:234.0pt;
mso-level-number-position:left;
margin-left:61.2pt;
text-indent:-61.2pt;}
@list l0:level9
{mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6\.%7\.%8\.%9\.";
mso-level-tab-stop:270.0pt;
mso-level-number-position:left;
margin-left:72.0pt;
text-indent:-72.0pt;}
@list l1
{mso-list-id:1780292287;
mso-list-template-ids:67698719;}
@list l1:level1
{mso-level-tab-stop:18.0pt;
mso-level-number-position:left;
margin-left:18.0pt;
text-indent:-18.0pt;}
@list l1:level2
{mso-level-text:"%1\.%2\.";
mso-level-tab-stop:54.0pt;
mso-level-number-position:left;
margin-left:39.6pt;
text-indent:-21.6pt;}
@list l1:level3
{mso-level-text:"%1\.%2\.%3\.";
mso-level-tab-stop:90.0pt;
mso-level-number-position:left;
margin-left:61.2pt;
text-indent:-25.2pt;}
@list l1:level4
{mso-level-text:"%1\.%2\.%3\.%4\.";
mso-level-tab-stop:108.0pt;
mso-level-number-position:left;
margin-left:86.4pt;
text-indent:-32.4pt;}
@list l1:level5
{mso-level-text:"%1\.%2\.%3\.%4\.%5\.";
mso-level-tab-stop:144.0pt;
mso-level-number-position:left;
margin-left:111.6pt;
text-indent:-39.6pt;}
@list l1:level6
{mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6\.";
mso-level-tab-stop:180.0pt;
mso-level-number-position:left;
margin-left:136.8pt;
text-indent:-46.8pt;}
@list l1:level7
{mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6\.%7\.";
mso-level-tab-stop:216.0pt;
mso-level-number-position:left;
margin-left:162.0pt;
text-indent:-54.0pt;}
@list l1:level8
{mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6\.%7\.%8\.";
mso-level-tab-stop:234.0pt;
mso-level-number-position:left;
margin-left:187.2pt;
text-indent:-61.2pt;}
@list l1:level9
{mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6\.%7\.%8\.%9\.";
mso-level-tab-stop:270.0pt;
mso-level-number-position:left;
margin-left:216.0pt;
text-indent:-72.0pt;}
@list l2
{mso-list-id:1863517938;
mso-list-template-ids:-179411298;}
@list l2:level1
{mso-level-style-link:"Overskrift 1";
mso-level-tab-stop:19.85pt;
mso-level-number-position:left;
margin-left:0cm;
text-indent:0cm;}
@list l2:level2
{mso-level-style-link:"Overskrift 2";
mso-level-text:"%1\.%2\.";
mso-level-tab-stop:42.55pt;
mso-level-number-position:left;
margin-left:0cm;
text-indent:0cm;}
@list l2:level3
{mso-level-style-link:"Overskrift 3";
mso-level-text:"%1\.%2\.%3\.";
mso-level-tab-stop:45.35pt;
mso-level-number-position:left;
margin-left:0cm;
text-indent:0cm;}
@list l2:level4
{mso-level-text:"%1\.%2\.%3\.%4\.";
mso-level-tab-stop:19.85pt;
mso-level-number-position:left;
margin-left:0cm;
text-indent:0cm;}
@list l2:level5
{mso-level-text:"%1\.%2\.%3\.%4\.%5\.";
mso-level-tab-stop:19.85pt;
mso-level-number-position:left;
margin-left:0cm;
text-indent:0cm;}
@list l2:level6
{mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6\.";
mso-level-tab-stop:19.85pt;
mso-level-number-position:left;
margin-left:0cm;
text-indent:0cm;}
@list l2:level7
{mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6\.%7\.";
mso-level-tab-stop:19.85pt;
mso-level-number-position:left;
margin-left:0cm;
text-indent:0cm;}
@list l2:level8
{mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6\.%7\.%8\.";
mso-level-tab-stop:19.85pt;
mso-level-number-position:left;
margin-left:0cm;
text-indent:0cm;}
@list l2:level9
{mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6\.%7\.%8\.%9\.";
mso-level-tab-stop:19.85pt;
mso-level-number-position:left;
margin-left:0cm;
text-indent:0cm;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span lang=NO-NYN style='font-size:
10.0pt;font-family:Arial'>Hi<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=NO-NYN style='font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Have some layers accessable as WFS layers, using OGR/ODBC. I
am fetching the records from an MS SQLSERVER/ORACLE. The layer is a POINT
layer.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Been testing some WFS FILTER expressions using the matchCase='false'
attribute in an PropertyIsLike filter.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>When I FILTER a layer from MS SQLSERVER or ACCESS the matchCase='false'
works. I can make a query on a attribute and I get the correct records
regardless if I use upper or lowercase.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>But if I try the same filter on a layer from ORACLE the matchCase='false'
does not seem to work..at least my query is case sensitive.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Are there any issues using OGR/ODBC and matchCase='false' in
a WFS PropertyIsLike filter?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Regards<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Sture<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=NO-NYN
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=NO-NYN
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>