<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#ffffff" text="#000000">
Hi all,<br>
<br>
any explanation why these request does not work <br>
<br>
<big><big></big></big>
<pre><big><font size="1"><big> INSERT INTO ICE_GEOM (ID, TYPE, ICE_POLYGON)
VALUES (2, 'ice', 'FME', </big></font><big><font
style="font-size: 8pt;" size="1"><big><big>
GeometryFromText('POLYGON((0.672702 49.9706, 3.90024 49.97063, 3.90024 47.6684,
0.672702 47.6684, 0.672702 49.9706 ))', -1 )</big></big></font><big><font
size="1"><big><big><big>);</big></big></big></font></big></big></big></pre>
<p><big><big><big> </big></big></big></p>
<meta name="GENERATOR" content="OpenOffice.org 2.0 (Linux)">
<meta name="CREATED" content="20070214;10404200">
<meta name="CHANGED" content="20070621;18272000">
<style type="text/css">
<!--
@page { size: 21cm 29.7cm; margin: 2cm }
P { margin-bottom: 0.21cm }
--></style><big></big>
<p style=""><br>
and this one works :<br>
</p>
<pre><big><big><font size="1"><big>INSERT INTO ICE_GEOM (ID, TYPE, ICE_POLYGON)
VALUES (2, 'ice', 'FME', </big></font><big><font
style="font-size: 8pt;" size="1"><big><big>
GeometryFromText('POLYGON((0.67 49.97, 3.90 49.97, 3.90 47.66,
0.67 47.66, 0.672 49.97 ))', -1 )</big></big></font><big><font
size="1"><big><big><big>);</big></big></big></font></big></big></big></big></pre>
<p style=""><br>
The difference is just the precision of LONG,LAT.<br>
The ICE_GEOM column has -1 SRID...<br>
</p>
<p style="">Where can i find WKT specification ?<br>
</p>
<p style="">Thanks<br>
</p>
<pre class="moz-signature" cols="72">--
Sébastien Geindre
</pre>
</body>
</html>