*0x* 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).
E.g. 255 decimal = binary = 0xFF [hexadecimal]
Kind regards
Peter
er 15, 2016 1:03 PM
Subject: [postgis-users] Problem extracting SQL Server Geometry (or, what is
the 0x character?)
G'day all,
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 appe
G'day all,
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