<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; color: rgb(0, 0, 0); font-size: 14px; font-family: Calibri, sans-serif;">
<div>
<div>Jukka,</div>
<div><br>
</div>
<div>The issue is not only the NLS format, which would govern the output and how the sql is interpreted, but there is also the issue of the lexer which is reading the xml request. And that would have to change also. </div>
<div><br>
</div>
<div>Its also unclear to me if XML / WFS allows other characters as a decimal character. I've yet to find any xsd or guide docs that indicate one way or the other. </div>
<div><br>
</div>
<div>Mike</div>
<div>
<div>
<div>----</div>
<div>Michael Smith</div>
</div>
<div>US Army Corps</div>
<div>Remote Sensing GIS/Center</div>
<div>michael.smith@usace.army.mil</div>
<div><br>
</div>
</div>
</div>
<div><br>
</div>
<span id="OLK_SRC_BODY_SECTION">
<div style="font-family:Calibri; font-size:11pt; text-align:left; color:black; BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt">
<span style="font-weight:bold">From: </span>"Rahkonen Jukka (MML)" <<a href="mailto:jukka.rahkonen@maanmittauslaitos.fi">jukka.rahkonen@maanmittauslaitos.fi</a>><br>
<span style="font-weight:bold">Date: </span>Tuesday, May 19, 2015 at 5:08 PM<br>
<span style="font-weight:bold">To: </span>"Lime, Steve D (MNIT)" <<a href="mailto:Steve.Lime@state.mn.us">Steve.Lime@state.mn.us</a>>, "<a href="mailto:Steve.Toutant@inspq.qc.ca">Steve.Toutant@inspq.qc.ca</a>" <<a href="mailto:Steve.Toutant@inspq.qc.ca">Steve.Toutant@inspq.qc.ca</a>>,
MapserverList OSGEO <<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a>><br>
<span style="font-weight:bold">Cc: </span>"<a href="mailto:Michael.Smith@erdc.dren.mi">Michael.Smith@erdc.dren.mi</a>" <<a href="mailto:Michael.Smith@erdc.dren.mi">Michael.Smith@erdc.dren.mi</a>><br>
<span style="font-weight:bold">Subject: </span>Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs getFeature with filter on numeric field<br>
<span style="font-weight:bold">Resent-From: </span>Michael Smith <<a href="mailto:michael.smith@usace.army.mil">michael.smith@usace.army.mil</a>><br>
</div>
<div><br>
</div>
<div 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">
<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";}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Seliteteksti Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.SelitetekstiChar
{mso-style-name:"Seliteteksti Char";
mso-style-priority:99;
mso-style-link:Seliteteksti;
font-family:"Tahoma","sans-serif";}
span.Shkpostityyli20
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.Shkpostityyli21
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.pl-s
{mso-style-name:pl-s;}
span.pl-pds
{mso-style-name:pl-pds;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
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]-->
<div lang="FI" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);">Hi,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);">Without being a programmer I would like to see what would happen if this source file
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);"><a href="https://github.com/mapserver/mapserver/blob/branch-7-0/maporaclespatial.c">https://github.com/mapserver/mapserver/blob/branch-7-0/maporaclespatial.c</a><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);">would be edited around line 571-573:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">cmd = <span class="pl-pds">"</span><span class="pl-s">alter session set NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss'</span><span class="pl-pds">"</span>;<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">by adding a new block for setting the decimal and thousands separators for output<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">cmd = <span class="pl-pds">"</span><span class="pl-s">alter session set NLS_NUMERIC_CHARACTERS='. '”</span>;<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">I am not sure of the right syntax. This one works with SQL*Plus and set decimal points and space for thousands separator. I think that thousands should be without separators but the command seems to require two inputs.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">-Jukka Rahkonen-<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="font-size: 10pt; font-family: Tahoma, sans-serif;">Lähettäjä:</span></b><span lang="EN-US" style="font-size: 10pt; font-family: Tahoma, sans-serif;">
<a href="mailto:mapserver-users-bounces@lists.osgeo.org">mapserver-users-bounces@lists.osgeo.org</a> [<a href="mailto:mapserver-users-bounces@lists.osgeo.org">mailto:mapserver-users-bounces@lists.osgeo.org</a>]
<b>Puolesta </b>Lime, Steve D (MNIT)<br>
<b>Lähetetty:</b> 19. toukokuuta 2015 22:12<br>
<b>Vastaanottaja:</b> <a href="mailto:Steve.Toutant@inspq.qc.ca">Steve.Toutant@inspq.qc.ca</a>; MapserverList OSGEO<br>
<b>Kopio:</b> <a href="mailto:Michael.Smith@erdc.dren.mi">Michael.Smith@erdc.dren.mi</a><br>
<b>Aihe:</b> Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs getFeature with filter on numeric field<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);">Is there somewhere in the capabilities response where a user would declare what decimal separators are supported?
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size: 11pt; font-family: Calibri, sans-serif;">From:</span></b><span lang="EN-US" style="font-size: 11pt; font-family: Calibri, sans-serif;"><a href="mailto:mapserver-users-bounces@lists.osgeo.org">mapserver-users-bounces@lists.osgeo.org</a>
[<a href="mailto:mapserver-users-bounces@lists.osgeo.org">mailto:mapserver-users-bounces@lists.osgeo.org</a>]
<b>On Behalf Of </b><a href="mailto:Steve.Toutant@inspq.qc.ca">Steve.Toutant@inspq.qc.ca</a><br>
<b>Sent:</b> Tuesday, May 19, 2015 2:06 PM<br>
<b>To:</b> MapserverList OSGEO<br>
<b>Cc:</b> <a href="mailto:Michael.Smith@erdc.dren.mi">Michael.Smith@erdc.dren.mi</a><br>
<b>Subject:</b> Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs getFeature with filter on numeric field<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span lang="EN-US" style="font-size: 10pt; font-family: Arial, sans-serif;">It seems to be a bug isn't?</span><span lang="EN-US"><br>
</span><span lang="EN-US" style="font-size: 10pt; font-family: Arial, sans-serif;">Do you want me to open an issue?</span><span lang="EN-US"><o:p></o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse">
<tbody>
<tr style="height:6.0pt">
<td width="40%" valign="top" style="width:40.0%;padding:0cm 0cm 0cm 0cm;height:6.0pt">
<p class="MsoNormal"><b><span style="font-size: 7.5pt; font-family: Arial, sans-serif;">"Smith, Michael ERDC-RDE-CRREL-NH" <<a href="mailto:Michael.Smith@erdc.dren.mil">Michael.Smith@erdc.dren.mil</a>></span></b><span style="font-size: 7.5pt; font-family: Arial, sans-serif;"></span><o:p></o:p></p>
<p style="mso-line-height-alt:6.0pt"><span style="font-size: 7.5pt; font-family: Arial, sans-serif;">2015-05-19 12:24</span><o:p></o:p></p>
</td>
<td width="59%" valign="top" style="width:59.0%;padding:0cm 0cm 0cm 0cm;height:6.0pt">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse">
<tbody>
<tr style="height:15.75pt">
<td width="57" valign="top" style="width:42.75pt;padding:0cm 0cm 0cm 0cm;height:15.75pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="font-size: 7.5pt; font-family: Arial, sans-serif;">A</span><o:p></o:p></p>
</td>
<td valign="top" style="padding:0cm 0cm 0cm 0cm;height:15.75pt">
<p class="MsoNormal"><span style="font-size: 7.5pt; font-family: Arial, sans-serif;">"<a href="mailto:Steve.Toutant@inspq.qc.ca">Steve.Toutant@inspq.qc.ca</a>" <<a href="mailto:Steve.Toutant@inspq.qc.ca">Steve.Toutant@inspq.qc.ca</a>></span><o:p></o:p></p>
</td>
</tr>
<tr style="height:15.75pt">
<td width="57" valign="top" style="width:42.75pt;padding:0cm 0cm 0cm 0cm;height:15.75pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="font-size: 7.5pt; font-family: Arial, sans-serif;">cc</span><o:p></o:p></p>
</td>
<td valign="top" style="padding:0cm 0cm 0cm 0cm;height:15.75pt">
<p class="MsoNormal"><span style="font-size: 7.5pt; font-family: Arial, sans-serif;">"Rahkonen Jukka (MML)" <<a href="mailto:jukka.rahkonen@maanmittauslaitos.fi">jukka.rahkonen@maanmittauslaitos.fi</a>>, MapserverList OSGEO <<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a>></span><o:p></o:p></p>
</td>
</tr>
<tr style="height:15.75pt">
<td width="57" valign="top" style="width:42.75pt;padding:0cm 0cm 0cm 0cm;height:15.75pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="font-size: 7.5pt; font-family: Arial, sans-serif;">Objet</span><o:p></o:p></p>
</td>
<td valign="top" style="padding:0cm 0cm 0cm 0cm;height:15.75pt">
<p class="MsoNormal"><span style="font-size: 7.5pt; font-family: Arial, sans-serif;">Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs getFeature with filter on numeric field</span><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><o:p> </o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="393" style="width:294.75pt;border-collapse:collapse">
<tbody>
<tr style="height:6.0pt">
<td width="57" valign="top" style="width:42.75pt;padding:0cm 0cm 0cm 0cm;height:6.0pt">
</td>
<td width="336" valign="top" style="width:252.0pt;padding:0cm 0cm 0cm 0cm;height:6.0pt">
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal" style="mso-line-height-alt:6.0pt"><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span lang="EN-US"><br>
<br>
<br>
</span><span lang="EN-US" style="font-size: 10pt; font-family: Calibri, sans-serif;">It looks like whats happening is that’s being converted into 3 Tokens and the oracle driver converts it into a number + comma + number.
</span><span lang="EN-US"><br>
<br>
</span><span lang="EN-US" style="font-size: 10pt; font-family: Calibri, sans-serif;">The tokenizer is not treating that value as a single value.
</span><span lang="EN-US"><br>
<br>
</span><span lang="EN-US" style="font-size: 10pt; font-family: Calibri, sans-serif;">Mike</span><span lang="EN-US"><br>
<br>
</span><b><span lang="EN-US" style="font-size: 10pt; font-family: Calibri, sans-serif;">From:
</span></b><span lang="EN-US" style="font-size: 10pt; font-family: Calibri, sans-serif;">"</span><span lang="EN-US"><a href="mailto:Steve.Toutant@inspq.qc.ca"><span style="font-size: 10pt; font-family: Calibri, sans-serif;">Steve.Toutant@inspq.qc.ca</span></a></span><span lang="EN-US" style="font-size: 10pt; font-family: Calibri, sans-serif;">"
<</span><span lang="EN-US"><a href="mailto:Steve.Toutant@inspq.qc.ca"><span style="font-size: 10pt; font-family: Calibri, sans-serif;">Steve.Toutant@inspq.qc.ca</span></a></span><span lang="EN-US" style="font-size: 10pt; font-family: Calibri, sans-serif;">><b><br>
Date: </b>Tuesday, May 19, 2015 at 11:44 AM<b><br>
To: </b>Michael Smith <</span><span lang="EN-US"><a href="mailto:michael.smith@erdc.dren.mil"><span style="font-size: 10pt; font-family: Calibri, sans-serif;">michael.smith@erdc.dren.mil</span></a></span><span lang="EN-US" style="font-size: 10pt; font-family: Calibri, sans-serif;">><b><br>
Cc: </b>"Rahkonen Jukka (MML)" <</span><span lang="EN-US"><a href="mailto:jukka.rahkonen@maanmittauslaitos.fi"><span style="font-size: 10pt; font-family: Calibri, sans-serif;">jukka.rahkonen@maanmittauslaitos.fi</span></a></span><span lang="EN-US" style="font-size: 10pt; font-family: Calibri, sans-serif;">>,
MapserverList OSGEO <</span><span lang="EN-US"><a href="mailto:mapserver-users@lists.osgeo.org"><span style="font-size: 10pt; font-family: Calibri, sans-serif;">mapserver-users@lists.osgeo.org</span></a></span><span lang="EN-US" style="font-size: 10pt; font-family: Calibri, sans-serif;">><b><br>
Subject: </b>Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs getFeature with filter on numeric field</span><span lang="EN-US"><br>
<br>
</span><span lang="EN-US" style="font-family: Calibri, sans-serif; color: rgb(0, 64, 128);">here is the mapserver log with
</span><span lang="EN-US" style="font-size: 10pt; font-family: Arial, sans-serif;"><ogc:PropertyIsEqualTo matchCase="true"><ogc:PropertyName>LONG_STAT</ogc:PropertyName><ogc:Literal>-61,8031</ogc:Literal></ogc:PropertyIsEqualTo></span><span lang="EN-US" style="font-size: 10pt; font-family: Calibri, sans-serif;"><br>
</span><span lang="EN-US" style="font-family: Calibri, sans-serif; color: rgb(0, 64, 128);"><br>
msOracleSpatialLayerWhichShapes. Using this Sql to retrieve the data: SELECT ID, NO_STAT_CLIM, NO_STAT_FADQ, NOM_STAT, LATI_STAT, LONG_STAT, ALTI_STAT, D_DEB, D_FIN, TIMB_MAJ, USAG_MAJ, rownum, GEOM_POIN FROM (select * FROM SMDVDP_STAT_METE WHERE EXTRACT(YEAR
FROM D_DEB) = 2014) WHERE ( LONG_STAT = -61.000000,8031.000000 ) AND SDO_FILTER( GEOM_POIN, MDSYS.SDO_GEOMETRY(2003, :srid, NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates ),'querytype=window') = 'TRUE'</span><span lang="EN-US" style="font-size: 10pt; font-family: Calibri, sans-serif;"><br>
<br>
</span><span lang="EN-US" style="font-family: Calibri, sans-serif; color: rgb(0, 64, 128);"><br>
The problem is</span><span lang="EN-US" style="font-size: 10pt; font-family: Calibri, sans-serif;"></span><span lang="EN-US" style="font-family: Calibri, sans-serif; color: rgb(0, 64, 128);"><br>
WHERE ( LONG_STAT = -61.000000,8031.000000 )</span><span lang="EN-US"> <o:p></o:p></span></p>
</div>
</div>
</div>
</span>
</body>
</html>