<div dir="ltr"><div><div><div><b>0x</b> is the prefix used in computing to indicate the following number is represented in base 16 (hexadecimal). WKB is Well Known Binary, you are seeing the binary (base 2) represented in hexadecimal base (base 16).<br><br></div>E.g. 255 decimal = 11111111 binary = 0xFF [hexadecimal]<br><br></div>Kind regards<br><br><br></div>Peter<br></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><table><tbody><tr style="font-size:12px"><td colspan="2"><b><a href="http://3xe.co.uk/" target="_blank">3XE</a></b>
</td>
</tr>
<tr style="font-size:10px">
<th style="width:15px;text-align:left">P:</th>
<td>01326 567155</td>
</tr>
<tr style="font-size:10px">
<th style="width:15px;text-align:left">M:</th>
<td>07770 693662</td>
</tr>
<tr style="font-size:10px">
<th style="width:15px;text-align:left;vertical-align:top">A:</th>
<td>3XE Ltd<br>Tremough Innovation Centre<br>PENRYN<br>TR10 9TA</td>
</tr>
<tr style="font-size:10px" align="left">
<td colspan="2">3XE Ltd · Registered in England and Wales · 9356871</td></tr></tbody></table></div></div></div></div></div></div></div>
<br><div class="gmail_quote">On 15 October 2016 at 01:03, Ben Madin <span dir="ltr"><<a href="mailto:ben@ausvet.com.au" target="_blank">ben@ausvet.com.au</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">G'day all,<div><br></div><div>I hope a simple case of something I've missed, but we are trying to extract data from a SQL Server database into PostGIS use tds_fdw... the data in SQL Server appears to be in WKB - but when when connect to this field we have a precursor 0x. I can't find any references to anyone else suffering this problem, but that could be because I'm trying a lazy approach to automate retrieval of hundreds of tables using the FDW (that's what it is for, right?)</div><div><br></div><div>I'm left with a sense that it is an encoding error between the two systems? I've tried making the fdw column text instead of geometry, but I can't get rid of the 0x, and no amount of trying to cajole the text to any other form makes it any happier. </div><div><br></div><div>To complicate it, for testing I'm going from SQL Server 2014 (running in Windows 8.1 in a VM) to PostgreSQL 9.4 on a Mac (El Capitan) using tds_fdw compiled on the same mac. POSTGIS="2.2.2 r14797" GEOS="3.5.0-CAPI-1.9.0 r0" PROJ="Rel. 4.9.2, 08 September 2015" GDAL="GDAL 2.1.1, released 2016/07/07" LIBXML="2.7.8" LIBJSON="0.12.1" RASTER</div><div><br></div><div>Any ideas gratefully received? </div><div><br></div><div>cheers</div><div><br></div><div>Ben</div><div><br></div><div><br></div><div><br></div><div><br clear="all"><div><br></div><div class="m_-1278243726171450245gmail_signature"><div dir="ltr"><div dir="ltr"><div>m : <a href="tel:%2B61%20448%20887%20220" value="+61448887220" target="_blank">+61 448 887 220</a></div><div><br></div><div>e : <a href="mailto:ben@ausvet.com.au" target="_blank">ben@ausvet.com.au</a></div><div><br></div><div>10 High Street, Fremantle</div><div>Western Australia</div><div><br></div><div>on the web: <a href="http://www.ausvet.com.au" target="_blank">www.ausvet.com.au</a><br></div><div><br></div><div><br></div><div>This transmission is for the intended for a mailing list and is clearly never going to be confidential information. If you have received this transmission in error, apologies! The contents of this email are the likely ill-educated opinion of the writer only and are not endorsed by Ausvet unless expressly stated otherwise. Thanks for reading. An even bigger thanks for any help you can provide.</div></div></div></div>
</div></div>
<br>______________________________<wbr>_________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">http://lists.osgeo.org/<wbr>mailman/listinfo/postgis-users</a><br></blockquote></div><br></div>