<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:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.Shkpostityyli18
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.Shkpostityyli19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 2.0cm 70.85pt 2.0cm;}
div.WordSection1
{page:WordSection1;}
--></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="FI" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Hi,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">I think that the real trouble is that with certain database and client settings the numerical data that is stored into Oracle is not interpreted
correctly and correct place to fix the issue is somewhere very close to Oracle. Not in making GML parser to accept commas or to make WFS string comparisons to work correctly with numerical data in Oracle.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">GDAL had similar troubles for sure with Finnish, Italian and French locales and probably with all the other locales using comma as decimal separator
as well. In practice it meant for me that GDAL truncated decimal numbers “1234,56” at comma “1234”. For many years I used some workarounds but after this GDAL fix it has not been necessary any more:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><a href="http://trac.osgeo.org/gdal/ticket/5709">http://trac.osgeo.org/gdal/ticket/5709</a><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">I suggest to study the patch “'OCI: force NLS_NUMERIC_CHARACTERS to ". " (patch by giorgiomugnaini, #5709)'” and consider if it could be applied
to the native Oracle driver in Mapserver. I guess and hope that Mapserver would recognize the datatype correctly if the Oracle layer is configured to read Oracle through
</span><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">CONNECTIONTYPE
</span><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">OGR and GDAL 2.0 is in use.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Perhaps setting environment "ALTER SESSION SET NLS_NUMERIC_CHARACTERS = '. '" locally before starting Mapserver would be enough but I do not know
how and where to set it.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">-Jukka Rahkonen-<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">Steve.Toutant wrote:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Is there a documentation that says that it is not?</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Folks from gdal list also think that it is not supported...I guess you are right. But as I said on the gdal list, many countries are using a comma as a decimal separator....what other people on
the planet do?</span> <br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Anyway the comma is another problem that I try to manage later......</span>
<br>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif"">For now, We have an application that generate and launch spatial queries on WFS, matchCase=false by default. Before modifying the code I want to understand what is going on....</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif"">It seems,when using numeric value, that matchCase as no impact in PostGIS, but it is important in oracle to be set to true</span>
<br>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif"">gml_type = auto, returns double in postgis and oracle, so that is fine</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif"">A WFS getFeature with the operator PropertyIsEqualTo AND matchCase=<b>false</b></span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif"">using this value -64<b>.</b>225</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif"">PostGis: it works</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Oracle (from mike's test): it fails...matchCase must be set to true</span>
<br>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif"">A WFS getFeature with the operator PropertyIsEqualTo AND matchCase=<b>false</b></span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif"">using this value -64<b>,</b>225</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif"">PotsGis: not tested
</span><br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Oracle: it fails...matchCase must be set to true</span>
<br>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Is there a reason why, with oracle, matchCase should be set to true when using numeric value, or that could be fixed?</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Regards</span> <br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Steve</span> <o:p>
</o:p></p>
</div>
</body>
</html>