[postgis-users] postgis+zaurus 5500

[Jonathan Giorgio Ghellere]

Hello,

I've compiled postgresql+postgis+proj for a zaurus 5500 running openzaurus 3.
3.5 and used qgis in a x86 machine to connect to the database in the zaurus.
The database was created using the http://postgis.refractions.net/docs/c206.
html:

CREATE TABLE gtest ( ID int4, NAME varchar(20) );
SELECT AddGeometryColumn('dbname','gtest','geom',-1,'LINESTRING',2);
INSERT INTO gtest (ID, NAME, GEOM) VALUES (1, 'First Geometry', 
GeometryFromText('LINESTRING(2 3,4 5,6 5,7 8)', -1));

Everything goes ok, but, when I use QGIS (http://qgis.org), to retrieve a 
feature map it returns a blank screen. So, I debug QGIS in order to see how it 
was selecting map and got something like this:

select oid,asbinary(geom,'NDR') as qgs_feature_geometry from gtest where geom 
&& GeometryFromText('BOX3D(        1.529391         2.750000,        7.470609  
       8.250000)'::box3d,-1);

In psql that query line returns:

  oid  |                                                                
qgs_feature_geometry
-------+----------------------------------------------------------------------
------------------------------------------------------------------------------
 21265 | 
010200000004000000000000400000000000000840000000000000104000000000000014400000
00000000184000000000000014400000000000001C40000000000000204000000000
(1 row)

Ok, this line did not show much, but take a look in the same query in a x86 
machine:

  oid  |                                                                
qgs_feature_geometry
-------+----------------------------------------------------------------------
------------------------------------------------------------------------------
 19203 | 
000200000004000000000000000000004000000000000008400000000000001040000000000000
1440000000000000184000000000000014400000000000001C400000000000002040
(1 row)

It looks like the bytes are swapped. Do anybody knows why it's happening ?

tks for the help.

--
Jonathan Giorgio Ghellere
http://www.ecosconsult.com.br
EcosConsult Planejamento Ltda


_________________________
Linux - uvscan antivirus